RE: [ms_access] Adding Records to Bridge Table

Sat, 22 Apr 2006 13:33:03 -0700

Bob-

Let's start with the basics.  What is the structure of your three tables?
Your Event table should have a Primary Key.  Your People table should have a
Primary Key.  And the People_Event table should have a Primary Key that
combines the two fields.  In the People_Event table, use the Lookup Wizard
(one of the options under Data Type in Design view) to define a lookup from
the People key to the People table and from the Event key to the Event
table.

Now run the form wizard.  Choose fields from the Events table and the
People_Event table.  DO NOT choose fields from People.  Choose the option to
create a form with a subform, and you should be all set.

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 3:03 PM
To: [email protected]
Subject: RE: [ms_access] Adding Records to Bridge Table

I am just trying to get the very basics down of creating tow tables
and a bridge table and adding to the bridge table.

table 1 is called Event
table 2 is called Person

I want to create a form that will allow me to select an event and add
people to it. However, I don't want the user to be able to add
someone who is NOT on the Person database to the event.

I want them to be able to have some drop down (combo box) to
select them from.


I tried the following:

forms/new/form wizard

Select Event as table where data comes from

Fields selected on form:
Event.id and Event.date

Person.Fname and Person.Lname

How do you want to view your data?
selected Event
selected Form with SubForms

layout: datasheet

style: standard

form: attendance

Subform: donor subform

That allows me to see who is in an event, but because the form
doesn't include the PK of the person table I can't add to it. And even
if I could, I would need a way of knowing who is in the database and
what their PK was.

Can you offer any help?

I tried looking at the database you referred to, but it was too
complicated for me to figure out how they did it.

bob



On 22 Apr 2006 at 11:26, John Viescas wrote:

> Bob-
>
> 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
>
>
>
> 
>
>
>
>
>
> --
> 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



Reply via email to