I have a Sales Rep table full of sales reps which has a Primary Key field, this Primary Key field is a text field. This primary key also the users/sales reps name. For example John Biggs or Sally Smith.
I have a separate table, full of clients. Some of these clients are big clients who work with us globally and as such can be managed by multiple sales reps. As such there is a user list field on this table that identifies which reps are responsible for each client. E.g. ABC client is managed by John Biggs and Sally Smith.
I am looking to create a relationship between the Sales Rep table and the Client table between the Primary Key on the Rep table and User List field on the client table. Is this possible?