combo box showing up different info from different tables

[Frank Situmorang]

Hello Experts:

Can combo box show up information from diferent table??, for example in our
form we need to fill in material description, at the same time it can show up
the lowest material price ( from product table) provided by supplier ( from
supplier table).

Any idea?

Frank

 

[Klatuu]

Any control can contain data from any table or query.
What you want is an unbound combo box. You identify the source of the data
in the Row Source property. You can create a query that will present the
data from the other table or tables.