How to make a Checkbox Field and Text Field into 3 different Value Lists

[Fred Young]

First off, my Filemaker Pro "Skills"...

I know how to create some relations, simple scripts and calculations but nothing advanced really...

I got a database with several Layouts and Tables.

1 Layout and Table, Staff Management, is for adding staff and Database users.

Then I have a layout and table, Client Management, in which I want to create 3 Value List based from the Staff Management

In the Staff Management i got a field "Name" and a Checkbox "Department".

The Checkbox gets its values from a Value List "Departments" and has the custom values: "Sales", "Marketing" and "Admin".

Now, I want 3 different dropdown lists, Sales Rep:, Marketing Rep: and Admin Rep:, Containing the Names from the Staff Management field "Name" depending on if the values from the Checkbox list.

Some Reps will be both Sales and Marketing, and some are both Sales and Admin, and so on, so every selection combination in the Checkbox "Department" must be considered...

I'm very grateful if someone could help me out here or at least point me in the right direction.

I posted this in the Script forum as well, I don't know what to use for this one...

Thanks all! Great Forum!

/Freddy Young