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