| re: Gala Database
Hi Brenda,
Pardon my being so arbitrary about the Boolean fields. If Entrants, Judges
and Sponsors are mutually exclusive they could be held in a single numeric
field and presented in an Option Group.
--
-Larry-
--
"Larry Daugherty" <larrySpamNotdaugherty@verizon.net> wrote in message
news:vzInc.183784$L31.112407@nwrddc01.gnilink.net. ..[color=blue]
> Hi Brenda,
>
> How about taking a paragraph or two to explain what will be going on at[/color]
your[color=blue]
> gala event and then another paragraph or two to describe what you are[/color]
trying[color=blue]
> 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[/color]
in[color=blue]
> 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.[/color]
With[color=blue]
> 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[/color]
in[color=blue]
> 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[/color]
in[color=blue]
> 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" <brenda.sendall@ntlworld.com> wrote in message
> news:f8fc6bfe.0405090528.5ac76d80@posting.google.c om...[color=green]
> > 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[/color]
>
>[/color]
| 
