Changing value list used for a field depending on the content of another field.
I am using FP10 on osx 10.4
I am setting up a filemaker layout in which employees have to enter products.
I would like to restrict the field where the product type should be selected (dropdown - value list) based on the field where the employee has selected the brand.
Simple car example: employee selects BMW and can then only choose 1 series, 3 series, 5 series etc...
If he was to select Merc then he could only select A-class B-class C-class ....
I think this would mean that the value list used in the "type" field will have to change if the "brand" field is selected.
Is this possible in FP10? How do i do this? Are there any other options?
I must say that i am only starting out with filemaker...