I had 3 tables to start. A Client can have many Sites and many Projects. I added a 'Project Sites' Join table, to record which of a Client's Sites are associated with which Projects.
When I go to a Project and 'Add Project Site', I have to search through every Site to tie them together. Is it possible to limit my selection of Sites to only those that belong to the same Client?