Conditional Value List Basics?

[sflynn]

I want to make a value list display values based on what another field says. What I have is a field to describe what role a person plays on a Production i.e. "Contractor, Talent, Interview Subject". If the user selects Contractor, I want the next field to list "Producer, Director...", but if they select "Talent", I want that next field to list "Voice, Actor, Musician...". Can this be done?

Thanks in advance for your guidance.

[John Mark Osborne]

There is an example of how to do this on my web site using an example of countries and states that can easily modified to meet your needs:

http://www.filemakerpros.com/CONDBASIC.zip

[Ninjason]

John,

I downloaded the file and saw that the countries value list is filled with custom values that must be manually typed in. I also have your training videos in which you demonstrate conditional value lists with the category and customers value lists from your invoicing solution. The category value list was also manually typed in.

Is it possible for both value lists to "Use values from field"? I have been trying to implement this into a solution of mine, but I'm having trouble. Also, I'm trying to use them in a portal, so I don't know if that is messing things up as well.

Edited October 27, 2006 by Guest

[John Mark Osborne]

Sure, just base the first field on a value list displaying fields from a table but don't use a relationship. You can use either a custom list or a field based value list for the first field. Obviously, there is no choice but to use a field based on the field contents for the second field.

There is no difference when adding a conditional menu to a portal. Just make sure the primary key field used in the relationship exists in the table where the portal records are coming from.

[wedgeman]

I've got a related question issue..

I have a business solution with multiple tables (4 of which are listed here):

- Home (home page)

- Sites

- Work orders

- Employees (who may be assigned to multiple sites)

There is a value list in Home which is the employees' full name.

In Work orders, an employee would have access to that value list, which would show all of the employees related to that site (based on a relationship i have built with that employee's site assignment..

However, if he were assigned to 2 sites (ie., also related to a second record in the Sites table), he should be able to view all employees from both of those sites (ie., the value list pulldown would display all employees from both sites 1 and 2).

How can I make the conditional value list (which switches according to which site he is assigned to) ALSO have a combination of multiple sites?

Edited January 25, 2009 by Guest