Nested Relationships / ValueLists

[Colin Greene]

Has anyone any ideas? I am trying to get a Relationship and ValueList to work which is conditional (nested) on two or more input fields.

When I create a Relationship name between my LOOKUP and RESULTS tables I can AND one, two or more fields = fields which works if both input cells have a value, but I also need to offer a skip (blank cell) – in other words if the second or more field is not selected then the previous default lookup value remains.

The normal order of selection is COMPANY, ID_OPTION, LOCATION1.

Select dropdown value in COMPANY; result = default list (ID_OPTIONS) AND = default list (LOCATION1)

Select value in ID_OPTION, or leave blank = drill down (LOCATION1) = refined list (LOCATION1) and so on.

Thanks

[Ocean West]

i think this is what you are after... http://www.filemakermagazine.com/videos/hierarchical-value-lists-dependent-value-lists.html