A valuelist based on a valuelist

[LasseJ]

Hi all

I have a table called PRODUCTS which contains all of our products the following fields:

Type_of_customer: (young, senior, work camp, etc.)

Destination: (USA, Italy, El Salvador, etc.)

ArrivalDate: (ex. 12-09-2009, 09-10-2009)

There a few type of customers, more destinations and plenty of arrival dates.

I want to relate this table (PRODUCTS) to another table called CUSTOMERS by using 'type_of_customer' as relation.

My question is how to make dynamic valuelists in table CUSTOMER where:

'type_of_customer' limits the choices of 'Destination'.

And the 'type_of_customer' combined with 'Destination' limits the choices of 'ArrivalDate' in the CUSTOMER-table.

Meaning the possibilities of data in 'Destination' are defined and limited by the choen data in 'type_of_customer' and the possibilities of data in 'ArrivalDate' are limited by your choice of data in 'Destination' combined by the chosen type of data in 'type_of_customer'

Hopefully it makes sense...

Can anyone help me out on this one?

Best regards

Lasse

[Vaughan]

Look up condition value lists in FMP helps and here ate the forums. Basically you'll need to create a table to store the values, and create relationships to the table of values.

[LasseJ]

Hmm... I'm afraid I dont understand your suggestion. Could you please clarify?

When searching FMP help nothing comes up on condition value list.

Also, My values are already stored in table PRODUCTS. I can easily manage to create a relationship between the two tables. (For now I have used 'type_of_customer' as the relationship), but that brings up all possible values in 'Destination' and not only the ones related to the picked value in 'type_of_customer'

Regards

[Vaughan]

My bad, it should have been "conditional" value list.

[bcooney]

Maybe this demo will help: Link

[LasseJ]

Hi bcooney

A late 'Thank you'. It works like a charm now

@vaughan: a search on 'conditional value list' actually doesnt bring up any subjects in FM-help

Best regards

Lasse