Page 1 of 1

Lookup Two Tables Possible?

Posted: Tue Aug 03, 2021 12:55 pm
by pmjd
Hello,

I would like to be able to search and pull though reference information from data held in two different tables via the lookup on a form. Is this possible?

Re: Lookup Two Tables Possible?

Posted: Tue Aug 03, 2021 1:50 pm
by kev1n
Sure, you can use SQL joins in your lookup form.

Re: Lookup Two Tables Possible?

Posted: Wed Aug 04, 2021 12:41 pm
by pmjd
Thanks, will try it out.