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!!!

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.