Two into one

[ssancton]

Hey there,

I work in the entertainment industry. I've got a database setup with a Client Table, which books shows in a show Table. This relationship is well established, no problem there.

Now, I have a new company under our umbrella. I would like to set up a Client Table of it's own, so as to not mix up each others clients. That being said, all operations are done by us now, so I don't want to have two show tables. How can I get both Client tables filtering into one Show Table?

I.e. New Client table creating new records in the show table

Any suggestions would be much appreciated!!!

[Ender]

While it's possible to have two Client tables relating to one Show table, I would recommend using one Client table for both groups of Clients, and add a Client Type field (or something similar) to distinguish between them. They can then be kept separate in Finds and relationships by filtering by the Client Type.