Conditional Value List pop up based on checkbox criteria
I have two tables, "accounts" and "Contacts". For each account, I have a related table to distinguish if the account is a customer, sales rep, or both. These selections are made on my "accounts" layout by way of a value list & checkbox object.
I would like to create a pop up that allows the user to select only accounts that are of sales rep type.
I have looked at the options presented within the forums, but I don't understand how I would make a calculated field in my accounts table to list only those accounts which have a related record of type sales rep.
Maybe I need to create a separate table of sales reps that link to an account and then pull from there....
Any ideas would be appreciated.