AnsweredAssumed Answered

combining value lists

Question asked by silba2021 on Sep 20, 2010
Latest reply on Sep 22, 2010 by philmodjunk


combining value lists


I have two tables, one with a list of designers and one for developers. To manage the privileges for these individuals I have a third table for accounts. I have accounts in a relationship with both the designer and developer tables. To create an account I want to first select either designer or developer from a field and would like to create a drop down value list from that table.

Is there a way of changing the value list a field uses based on a particular selection in another field. Alternatively, is there a way to combine value lists and then filter it.

I am not sure if either of this is the best way to go about it but I would appreciate some input on the matter. Thanks