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