Field auto-population

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

I'm looking for information on how the many to many join table works in
Access. In Northwinds when you use the Orders form it populates the Order
Details table as well as the Order table.

I'd like to do the same thing in a database I'm building, but can't figure
out how. My basic desire is to create a form to look up the primary key of
one table, fill foriegn key of the join table with that value and then be
able to fill in another form that fills the other foriegn key in the join
table. I'm not describing it very well, sorry.

Anyone who could help would be appreciated.
M
 
Hi all,

I'm looking for information on how the many to many join table works in
Access. In Northwinds when you use the Orders form it populates the Order
Details table as well as the Order table.
Click to expand...

Ummm... No. It doesn't.

THe Order form is used to fill the fields of the Orders table. The
OrderDetails Subform on that form is used to fill the Order Details
table. Two forms, one within the other.
I'd like to do the same thing in a database I'm building, but can't figure
out how. My basic desire is to create a form to look up the primary key of
one table, fill foriegn key of the join table with that value and then be
able to fill in another form that fills the other foriegn key in the join
table. I'm not describing it very well, sorry.
Click to expand...

Use a Subform. The Master Link Field value will be automatically
filled into the Child Link Field of the subform. Look at the Orders
form again, and examine the properties of the OrderDetails subform.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top