Worked like a charm! Thank you very, very much.
bob
On 22 Apr 2006 at 15:31, John Viescas wrote:
> 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
>
>
>
>
>
>
>
>
> --
> 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]
SPONSORED LINKS
| Microsoft access database | Database development software | Database management software |
| Database software | Inventory database software | Membership database software |
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.
