Merge two fields

[Bruno Dini]

Hello,

I'm trying to do this but I can't figure out how.

I have this database with one Table for clients and another for partners. Insite this tables I have the fields clients_id and partners_id

I wanna make now a payment table in this database, but the payments can come from the partners and from the clients.

Is there any way that I can show both fields (clients_id and partners_id) in the same drop down list? Insite the Payments table?

Thanks!

[corn]

Instead of having two tables consider instead one or three.

In the single-table scenario you would combine all of the attributes of both tables into a single "Person" table and add a field to designate the type of person the record represents.

In the three-table scenario you would combine all of the common attributes into a single "Person" table with a primary key "PersonID" unique for each person. This key also serves as the primary key for the clients and partners tables.

Your payments table would use the "PersonID" which would allow you to get to the demographic data for both clients and partners.

[Bruno Dini]

Hello,

I tried to do this "universal Person ID". I don't know if I'm doing something wrong, but it didn't work out.

The partners and clients already have their IDs: for example

C001 for clients and P001 for partners.

I didn't understand how can I combine this atributes in the payments table.