List dependencies on property set

[ABanzhaf]

Hey,

i defined two lists in a property set and i want get them into dependency. For example when i pick the floortype of a room out of a list i want to automatically pick a value from another list

For example: wood = 1,  concrete = 2,  PVC = 3 etc.

The floortype and the values are pre defined in the list definitions.

Thanks so far !

[David_W_Koch]

I do not know of a way to link two Lists as you describe, but what you could do is set up the "driving" List from which the user selects as a List Definition, and then create a Formula property that would read the value chosen and, using a Case statement, return the associated value.

[David_W_Koch · Accepted solution]

To clarify, the statement needed is Select Case, not Case.  The attached file, done in ACA 2019 (2018 file format), is a small sample file that demonstrates how a formula property can return a given value based on the value of another property, in this case one whose value is chosen from a List.

[ABanzhaf]

Thank you very much ! Works perfectly !