Mulitple Lookup Tables

  • Thread starter Thread starter SJ Mo2
  • Start date Start date
S

SJ Mo2

I am trying to set-up a field that will allow me to choose a value
from one of three separate tables/lists. I want all three of these
lists to be on my form and the user can choose a value from any one of
the three for that field. I am not sure how to set-up the look-up and
the actual form data.

Thanks
 
These needs (and should) be done from a form. Am I correct in assuming you
want to change the Row Source property of the combo box based on some other
value/expression?
 
Not exactly...I want to be able (on a form) to choose a value for a
specific field from one of several list bozes. For example, I want
the user to select a value for the field CPT1 in my table tblCodes on
a form from one of three separate list boxes which each relate to a
different table. I have the form with the list boxes etc... but I
can't figure-out how to select the value from more than one possible
list.

Does that make sense?

Thanks
 
Not exactly...I want to be able (on a form) to choose a value for a
specific field from one of several list bozes. For example, I want
the user to select a value for the field CPT1 in my table tblCodes on
a form from one of three separate list boxes which each relate to a
different table. I have the form with the list boxes etc... but I
can't figure-out how to select the value from more than one possible
list.

Does that make sense?
Click to expand...

Not really! If you want CPT1 to be drawn from a list of values, it
should be *ONE* list of values. You certainly will not be able to
enforce relational integrity to three different tables! What are these
three listboxes? How do they differ? What is CPT1 and why is it set up
this way?

Two comments to answer your question directly though:

- You can have multiple controls on a Form all bound to the same field
(CPT1 in this case). If you select a value from one of them it will
override any selection from the others; if the three listboxes' row
source properties are different, it's most likely that two of the
listboxes will be blank, since the selected value isn't valid for that
listbox's rowsource.

- You could use a single listbox based on a UNION query stringing the
three tables together. See UNION in the online help.
 
Back
Top