Form for Many-many input

  • Thread starter Thread starter MMG
  • Start date Start date
M

MMG

I have a typical 3 table, many-many data structure (call
them A B and AB. What is the best way to provide data
entry for this relationship - The User will be working
with or creating records in A, and selecting existing
entries or creating new ones in B to associate with the A
entry through the AB table. I have no trouble creating a
form/subform that allows new entries for this
relationship, but I get lost when I try to allow either
selecting existing or adding new to the B side.
 
I have a typical 3 table, many-many data structure (call
them A B and AB. What is the best way to provide data
entry for this relationship - The User will be working
with or creating records in A, and selecting existing
entries or creating new ones in B to associate with the A
entry through the AB table. I have no trouble creating a
form/subform that allows new entries for this
relationship, but I get lost when I try to allow either
selecting existing or adding new to the B side.
Click to expand...

There is a fair bit of assymetry in this situation. It's easy to have
a Form for A with a subform for AB - but as you've found, adding to B
can be a bit of a hassle.

Take a look at the Orders form in the Northwind sample database. It
uses a very common approach - a Combo Box on the subform based on B,
with code in the combo's NotInList event to pop up a data entry form
for B if the desired item does not exist.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
John, I looked at the Nortwinds database, Orders form (with Orders Subform)
and I can't find any combo box with any code in the not in list event. In
fact, I thought I remembered something like that from when I did some Access
work years ago - but it's not in the Office XP version. Any suggestions on
where I can find this?
 
John, I looked at the Nortwinds database, Orders form (with Orders Subform)
and I can't find any combo box with any code in the not in list event. In
fact, I thought I remembered something like that from when I did some Access
work years ago - but it's not in the Office XP version. Any suggestions on
where I can find this?
Click to expand...


Try

http://www.mvps.org/access/forms/frm0015.htm

John W. Vinson[MVP]
 
Back
Top