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

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.

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

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

Maybe this demo will help: Link

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