conditional value list from value list?
I would like to indicate that people are authors, agents, or editors (in some cases may be more than one type), and then would like to indicate their role in the creation of a book. So I have a person table with the name, and (I hope) a check box set showing "Author" "Agent" or "Editor" (as custom values in a value list). I have a book table with fields for author, agent, and editor, and would like to use drop-down lists, based on the check boxes selected in the other table, to select authors, agents, and editors.
I've done the tutorial on conditional value lists, and understand how this is done using related fields, but is it possible to use a value list to create a conditional value list in this case?
Thanks for any help, I have been trying to figure this out for a week...