multiple field lookup

  • Thread starter Thread starter spence
  • Start date Start date
S

spence

This is probably a no-brainer but I'm a complete Access
novice who's inherited a database and is trying to augment
it with a billing module. Here's the deal:

I have a Client Table with separate fields for Individuals
and Agencies. In any given record there is either a value
in the Individual field OR the Agency field; the two are
always mutually exclusive. What I'm need to do is to be
able to create a combo box in a form that lists all
Individuals AND all Agencies in a single drop down list.
Seems like it would be simple enough but I'm baffled.

Thanks,
Spence
 
This is probably a no-brainer but I'm a complete Access
novice who's inherited a database and is trying to augment
it with a billing module. Here's the deal:

I have a Client Table with separate fields for Individuals
and Agencies. In any given record there is either a value
in the Individual field OR the Agency field; the two are
always mutually exclusive. What I'm need to do is to be
able to create a combo box in a form that lists all
Individuals AND all Agencies in a single drop down list.
Seems like it would be simple enough but I'm baffled.

Thanks,
Spence
Click to expand...

It sounds like a UNION query would be the ticket here. Do you have a
table of Individuals, and a table of Agencies? Which field from these
tables do you want to store in the Client table? An ID, or the
individual/agency name? It's doable, but we'll need a little more
information to say just how!

Do check out UNION in the online help though, it may give you enough
to go on with!
 
Back
Top