Simple filter dropdown list with related tables

[itz_nsn]

Hello, 

 

I am new to File Maker Pro and i a trying to find out how to do some simple reporting - i searched all around but could not find even 1 example that simply and straightforwardly explains how to do this 

 

I have 3 sample relational tables and i have some data in them ( all relations have been set up )

 

car_make ( id, make_name )

car_model ( id, model_name )

car ( id, car_make_id, car_model_id, color ) 

 

I need to set up a report with 1 dropdown list 

 

DropDown list = Car Make 

This should auto populate with all the entries in car_make table

When this changes, I need to find all related records in the car table and display all data ( all columns from all 3 tables - in a tabular format )

 

Can anyone help me with this or point to a good tutorial

[Matthew F]

What you actually want to do is have a value list that allows users to choose the proper car make ID by choosing from a popup list of Car Make names.   To do this first create a Value List using car_make::id as the primary field.  Check the option "Also display values from second field" and choose car_make::name.  Also select the "Show values only from second field" option.   Next, place the Car Make ID field on your layout.  Format the field as Pop Up Menu.  It will display the car make Name instead of the make ID.