RE: Help with multiple tables

Thanks again Wayne.
Now, I'm going to sleep before I go to my "real" job. I'm going to work on
it some more tomorrow morning after I get home from work and eat
supper/breakfast.
I will post how it's going and if I have any hair left, and post any more
questions I will probably have.
Mickey

"Wayne-I-M" wrote:

Hi Melinda

In the relationships window you will set up a 1 to many relationship but
when you do this to 3 or more tables its called a many to many

Think about the standard example - a school

There are man classes and many pupils.
Each class can have many pupils and each pupil can go to many classes.

In this case you would have

ClassID
PupilID

and a linking table
TableID
ClassID
PupilID

so it is (like your situation) a Many to Many relationship.

I would NOT base the forms on any tables
I "would" create a query based on the tabels and then base your forms,
reports on this (or these) queries.

There are lots of reasons for this such as you can sort a query. You can add
calculations, etc

DON'T do you reports yet. They are the end result. You should get the
database up and running 1st then then just look at the reports as a snapshot
of what you have on your database - or course reports can do more than this
but I thik that is what you are looking for

2 weeks should be OK as long as you keep it very simple - you can always add
to the application later. ust get it running first, change anything you find
is not working and then later your can look at improving it.

Good luck


you
--
Wayne
Manchester, England.



"Melinda" wrote:

Wayne,
Thank you very much for your quick response. I followed your instructions
and got the databases all set up. I had a little "snag" because I couldn't
remember where to find the relationships window - then looked at the "table
that data" training to remind myself that it's under the tools. :)
One question, though, the relationships window only showed one-to-many, not
a many-to-many, but it seemed to do it pretty much automatically. Is that
correct, or did I misunderstand what I was seeing?
Now, off I go to work on setting up the form to enter all the information
that will be needed from/for each database. After that, set up the reports to
have them all ready to "spit out" after this volunteer season is over with.
Amazing how simple it seems once you have someone who knows what they are
doing. :)
The worst (?) thing about this is that I was asked to do this with less than
2 weeks before our season starts. The person "in charge" was tired of having
to deal with all the "hard" data (i.e. paper, paper and more paper). To give
you a little better idea of what we do; every year between Thanksgiving and
Christmas, we Hams volunteer at a local Shopping Mall on the weekends. We
need to keep track of who shows up when, which section they work and what if
anything happened.
Again, Thanks so very much,
Mickey

ps - now lets see what lovely words I have to say to my computer as I work
on the forms and reports. :D All stations, please stand by for more crazy
questions from someone who doesn't know 1 - what to do, 2 - how to do it or 3
- why she's doing it! He He. Mickey

"Wayne-I-M" wrote:

Oh, I forgot to say.

I have use 3 tables as there may be more than one "thing to talk about"
during each time/date. So please don't be tempted to just put a memo field
in tblLogRecord. This is a common mostake (that many people not used to
referential databases make) and it would be you would end up with the same
data in different tables - BIG mistake.

So please do use the Many to Many setup I gave it really will make it work
better (eve if it take a few mins more to create)


--
Wayne
Manchester, England.



"Melinda" wrote:

I am trying to make a form/database for weekend volunteers. I need to be able
to input their Ham Radio Call Sign, Last Name, First Name, Phone number and
E-mail address. None of this info would change except maybe their phone
number.
When they show up the first time, all of this info would be entered and
stored in a table called volunteers. Every time they show up after that, only
their call sign (which is different for each person) would be used to
log/sign them in. On another line, in another table, would be a date field
which could be automatically filled in with the day's date - or, if need be,
the date could be entered manually, along with time in, time out and
area/zone worked. Then, a third table called Activity which would used if
anything happens during the "shift" that needs to be reported or discussed
later.
I can't figure out how to set up the tables so that the info from the date,
time in, time out, area/zone and activity are all associated with a
particular person. I also am not sure about how to set up the report pages,
but I figure one thing at a time for my poor brain to wrap itself around. :)
Any and all help would be greatly appreciated - especially the "dummies"
version.

Thanks in advance,
Melinda

ps - I've read all the tutorials and did the "training" for Access 2003 here
on Microsoft, but this is the first time I've ever tried to make anything
with Access and just can't seem to make my brain comprehend how to do it
correctly. Again, thanks. Mickey
.

Relevant Pages

  • RE: Help with multiple tables
    ... DON'T do you reports yet. ... database up and running 1st then then just look at the reports as a snapshot ... remember where to find the relationships window - then looked at the "table ... but this is the first time I've ever tried to make anything ...
    (microsoft.public.access.gettingstarted)
  • RE: Help with multiple tables
    ... DON'T do you reports yet. ... database up and running 1st then then just look at the reports as a snapshot ... remember where to find the relationships window - then looked at the "table ... we Hams volunteer at a local Shopping Mall on the weekends. ...
    (microsoft.public.access.gettingstarted)
  • RE: Help with multiple tables
    ... I have the database tables all set up and saved. ... DON'T do you reports yet. ... remember where to find the relationships window - then looked at the "table ... stored in a table called volunteers. ...
    (microsoft.public.access.gettingstarted)
  • RE: Help with multiple tables
    ... just wondering, you had said not to base my forms on the databases, but to ... DON'T do you reports yet. ... remember where to find the relationships window - then looked at the "table ... but this is the first time I've ever tried to make anything ...
    (microsoft.public.access.gettingstarted)
  • Re: SYSTEMS ENGINEER/ VAX-VMS/ CAREER POSITION
    ... System Administration and database admin from NIIT, ... salary details and generate reports and enclosures,and calculates ... Responsibilities: ... Write New programs from user requirements, Programming Changes ...
    (comp.os.vms)
Loading