M maquino New member Local time Today, 11:01 Joined Mar 8, 2002 Messages 8 May 21, 2002 #1 How can I make a lookup in more than one table? For example I want to have a lookup that lists the field "name" from 2 different tables("employees" and "suppliers") Thanks M<arcio
How can I make a lookup in more than one table? For example I want to have a lookup that lists the field "name" from 2 different tables("employees" and "suppliers") Thanks M<arcio
David R I know a few things... Local time Today, 05:01 Joined Oct 23, 2001 Messages 2,632 May 21, 2002 #2 Use a Union Query. Your data will not be updateable.