In your Contacts table you will need a field to display Type in which you store the values client, attorney, etc. In the Transactions table you will need a global field in which to enter the particular type you want your list to display. Then create a relationship between the two tables linking these two fields. Then create a value list to display the values from the Type field on the Contacts table, but check "show only related values" starting from Transactions.
Ok, not sure if that will work for my setup or I just am not understanding.
I have a many to many relationship between transaction and contact for
which a third table hub is used to collect the ID from the other two tables
to connect them. The "Client" field is defined within the third table (HUB)
after the transaction and contact is added to that table.
The transaction layout holds the portal for the HUB. Attempted to do what
you said but the result was only getting one of the contacts, out of four
would show up multiple times.
I will keep playing around with it, see if I can figure this out.
Thanks for your reply. I at east learned about that field you pointed out,
that might be result if I can get it to work.
It's A Good Life!
Raymond Kennedy, Realtor®
Illinois Real Estate Broker
Home Smart Realty Group
Direct: (815) 301-7007
Fax: (866) 346-9139
Orland Park IL 60462