Hello folks,
I would really appreciate your help on the programming logic of the
following example:
Let's say you have an invitees table with Invitees_ID and Invitees_Names
Assuming that you have another table this time with Events_ID and _Name.
Now I would like to be able to select invitees, some of them, and invite
them to q selected event.
Which logic should I use:
- Make a third table with gathered Invitees_ID and Events_ID?
- Make a table for each events' year so that it can last in the future?
Any correction/info will be greatly appreciated :)
Have a nice day
P.S. sorry about the other post in the forms section...
Beetle - 11 Jan 2008 14:46 GMT
You would make a third table with, for example, EventID and InviteeID fields
as a compund primary key, plus any other fields - like EventDate - that are
specific to each particular event

Signature
_________
Sean Bailey
> Hello folks,
>
[quoted text clipped - 15 lines]
>
> P.S. sorry about the other post in the forms section...
Kevin3NF - 11 Jan 2008 14:48 GMT
- Make a third table with gathered Invitees_ID and Events_ID?
Junction or many-to-many table...standard practice

Signature
Kevin3NF
SQL Server dude
You want fries with that?
http://kevin3nf.blogspot.com/
I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.
> Hello folks,
>
[quoted text clipped - 15 lines]
>
> P.S. sorry about the other post in the forms section...
The Dude - 11 Jan 2008 15:26 GMT
Ok I see...
thanks for your answers :)