Hello,

Here is what I have:

One table for company client data (Limited).

One table for individual client data (individual).

To assist with queries in the future I created a combo box in both the above tables for the user to identify whether the record is for an individual or a limited company.

a combo table with "Limited" and "Individual" in them for the above.

I want to create a combo box on my main screen with a list of all clients in the database to allow the user to open the relevant client record.

But the records are stored in separate tables by type of client.

How do I create the link using the two client tables in combo box?  I presume it is handy I have created the "type of client" combo box in each record and table?

Thanks,

Neetiay

---

Reply from Alex Hedley:

I'm a little confused by the set up, if they are in different Tables why do you need to distinguish them with a field of Type.
If they have the same Fields why not store them in the same Table with an extra column of Type which is either of the two.
If this isn't an option but they have the same Fields why not create a UNION query to join both Tables together.