Northwind.mdb is a sample file that gets installed with Access. If you have
Access 2002 or 2003, you can choose Sample Files from the Help menu to find
it. Otherwise, use Windows Explorer to search for it on your hard drive.
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 Rosenblum
Sent: Saturday, April 22, 2006 11:23 AM
To: [email protected]
Subject: RE: [ms_access] Adding Records to Bridge Table
John
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
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.
