The purpose of my form is to record multiple owners of businesses. The main form
displays the business records. Subform1 is a continuous form consisting of only
a combobox to select owners from a table of owners. Subform1 contains record
selectors so after owners are entered, a specific owner can be selected. PK is
OwnerID. Subform2 is a single form based on the same owner table and its purpose
is to display details about the selected owner in Subform1. Foreign key is
OwnerID.
Since Subform1 is a continuous form, I have Subform2 external to Subform1. What
needs to be done so that as specific owners are selected in Subform1, Subform2
displays the related details about the owner selected inSubform1?
Thanks,
Tom