Query or lookup table?

A

Amit

Hi,

I have a field (facilitatorID) in a table whose value is
selected from fields in two different tables (employeeID
from "employee table" or partnerID from "partner table").
What are the pros/cons of using a query vs a lookup table
as the source of facilitatorID using a combo box? This
will be in a form. Is one recommended over the other for
certain situations? Thanks for any insights on this.

-Amit
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combo Boxes/Queries 1
Lookup not showing records, also captions not displaying correctly 4
QBF & Query Malfunction 0
How to use a combo box in a bound form? 3
Combo Box Lookup Value 4
Using list box adds blank record to lookup table 1
Using Combo Box Selection to Query a Table 3
Unable to add new records to a form 0

Top