J
John Vinson
On Mon, 1 Dec 2003 20:36:05 -0800, roger1anickname
See the Orders form in the Northwind sample database for a worked-out
example.
Short answer:
Base the Form on one of the "one" side tables. Base a Subform on the
third table, the "resolver" table which is related one to many to both
"one" side tables. Put a Combo Box on the subform bound to the other
"one" side table, and use its NotInList event to (if need be) pop up a
separate form to update it when there is a new value.
See the Orders form in the Northwind sample database for a worked-out
example.
Short answer:
Base the Form on one of the "one" side tables. Base a Subform on the
third table, the "resolver" table which is related one to many to both
"one" side tables. Put a Combo Box on the subform bound to the other
"one" side table, and use its NotInList event to (if need be) pop up a
separate form to update it when there is a new value.