Take a look at the Orders form in Northwind. Orders and Products have the
same sort of relationship as your People and Events. An Order can have many
Products, and a Product can appear in many Orders. So, you need a form that
edits Events and a subform based on a query between People_Event and People
that lets you add rows to People_Event - just like the subform in Orders
lets you add rows to Order Details (the "bridge" table between Orders and
Products). Include a combo box on the People foreign key in People_Event
that looks up person names and sets the foreign key.
If you need more help, just ask...
John Viescas, author
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
Running Microsoft Access 2000
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
For the inside scoop on Access 2007, see:
http://blogs.msdn.com/access/
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf
Of Bob
Sent: Friday, April 21, 2006 8:03 PM
To: [email protected]
Subject: [ms_access] Adding Records to Bridge Table
I am trying to, and struggling with, adding records to a bridge table.
One table is of individuals, another is for events. Since people can
go to more than one event and an event has more than one person, I
need to create a people_Event bridge table.
I want to create a form that will allow you to add people to an event.
My "people" table has an acct number as text for a primary key. My
event table has a similar type of key, and a date and a couple other
bits of descriptive information.
Can anyone help me?
bob
Yahoo! Groups Links
YAHOO! GROUPS LINKS
- Visit your group "ms_access" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
