Thanks for your prompt reply. I can't find the file you referred to in
the files section of the ms_Access group. Could you send me a
link?
thanx
bob
On 21 Apr 2006 at 21:33, John Viescas wrote:
> Bob-
>
> 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
>
>
>
>
>
>
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.385 / Virus Database: 268.4.5/321 - Release Date: 4/21/2006
>
~
Bob Rosenblum
PO Box 3027
Albany, NY 12203
Phone: 518-459-6212
Email: [EMAIL PROTECTED]
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.
