newbie question Value lists and relationships
Hi , I'm new to filemaker and i want to setup a database with the following tables:
Car repair Table - Car Brand Table and a Car Model Table.
On the car repair layout i want to have two drop down fields.
On the first field I created a drop down list where you can choose the Car Brand (like BMW or Saab) from the Car Brand Table
On the second filed Ionly want to show the models of the selected Car Brand , that means If I choose BMW I only get the models of BMW , like 525 or 725 , If I choose Saab I only want to Choose the models of saab like 900 ... The Problem is I can choose the Card Brand but I see all the Models of all brands in the second field of the Car Model Table. How can I solve this to see only the models of the selected Brand?