Clients table help needed, filtering

[DCXtreme]

Hi, based on previous advice I had merged my customers and owners into one table and selected whether a client was a customer, owner or both via a lookup table.

This is working fine, however I must assign a rep to each owner, I'm not quite sure how to do this, I need to be able to assign a rep to an owner in the clients table, I must also make sure than a rep can not be assigned to someone who is just a customer obviously.

I have attached the database (http://jonroberts.redirectme.net/database.zip), hopefully that will make things more clear.

Thanks in advance.

 

[wazz]

link did not work for me.

 

[llkhoutx]

. . . nor for me.