Many to Many Form

[Arnold Klapheck]

I am looking for a tutorial or a good example of a form for lookup, input,
edit, etc.
I have a main table and an other table and they have a many to many
relationship. I use a bridge table with the primary key from the two table
and two fields that describe the relationship.

I have a form with the main table and the other table as a subform with the
two fields from the bridge table in the subform. Currently their is no
linking on my form between the tables. I want to be able to add and edit all
information on the form.

Any help would be appreciated.

 

[John W. Vinson]

I am looking for a tutorial or a good example of a form for lookup, input,
edit, etc.
I have a main table and an other table and they have a many to many
relationship. I use a bridge table with the primary key from the two table
and two fields that describe the relationship.

I have a form with the main table and the other table as a subform with the
two fields from the bridge table in the subform. Currently their is no
linking on my form between the tables. I want to be able to add and edit all
information on the form.

Any help would be appreciated.

You'll need to pick one of the "one" side tables as the "more active table".
You can't (at all easily, anyway) have BOTH one side tables open for new
additions at the same time.

If you look at the Orders form in the Northwind sample database, you'll see an
example; the Orders table is the recordsource of the form, and OrderDetails
(the bridge table between Orders and Products) is the recordsource of the
subform. There is a separate, independent form for entering Products; I
believe that the combo box on the subform has a Not In List event to pop up
the products form if a new product is needed.