AnsweredAssumed Answered

Conditional Value List pop up based on checkbox criteria

Question asked by Vinny on Mar 14, 2011
Latest reply on Mar 14, 2011 by philmodjunk

Title

Conditional Value List pop up based on checkbox criteria

Post

Hello,

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.

Outcomes