Thank you for your reply. Obviously I need to add some clarification to my example. Locations belong to only 1 client. Perhaps the table should have looked like this:

Locations As...