Looking up Owner Contact and Address

S

smboyd

I have a table of Owner - each Owner may have 1 - 5 contacts. On a form, I
want the user to be able to select and Owner, see a list of the contacts for
that owner, select a contact and have the address automatically filled in.

What is the easiest way to accomplish this?

I also want to give the user an option to "add" an Owner if the Owner
doesn't exist in the list.
 
Top