1 Reply Latest reply on Feb 16, 2010 3:20 AM by LaRetta_1

    Changing value list used for a field depending on the content of another field.

    fredn

      Title

      Changing value list used for a field depending on the content of another field.

      Post

      Hello all,

       

      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...