Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / January 2008

Tip: Looking for answers? Try searching our database.

A question of concept/logic

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
The Dude - 11 Jan 2008 14:30 GMT
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 :)
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.