Hi Brenda,
How about taking a paragraph or two to explain what will be going on at your
gala event and then another paragraph or two to describe what you are trying
to track. Don't assume we know.
As for primary keys, more often than not, I use autonumber keys and never
let another human being see them. If you do any AutoForms or AutoReports
and the autonumber fields are in the generated output, either delete them
and their labels or make them invisible.
I believe that Entrants, Judges and Sponsors could all be Boolean fields in
tblPerson
What are Events?
What are Categories?
What are Results?
So far it looks like a very simple application. Give as much help as you
can and you'll get all the help you need.
FYI: I and many other lurkers of the newsgroups use Outlook or Outlook
Express rather than the internet based tools for reading and posting. With
the internet based tools you usually have the whole thread seamlessly
displayed. For those tools it seems ridiculous and noisy to continually
copy the entire thread. However, with the vagaries of what newsgroups are in
view to the Outlook/Express user, sometimes only parts of threads appear.
Also, we only have one post of the thread open at a time with any
convenience. Therefore it makes sense to always have the entire thread in
each post, possibly with some judicious snipping.
p.s. In the time I've been typing this someone with answers to the
questions above could have provided you with answers to your questions.
:-)
HTH
--
-Larry-
--
"Brenda" <br************@ntlworld.com> wrote in message
news:f8**************************@posting.google.c om...
I have to design a data base for a Gala Event.
I need tables for:
Entrants
Judges
Sponsors
Categories
Results/Event
I take it the above will be my five tables. Can someone identify the
primary keys here for me and the relationships between the five
tables? I have tried but always end up with one relation being
indeterminate.........!
It is getting very frustrating now
Brenda