Car Database

[REGGIE MAGER]

Hi everyone. I'm a newbie to both the forum and Filemaker Pro. Here's what I'm trying to accomplish. I'm setting up a database to track our repair shop customers and vehicles. I have a database called cars which lists the vehicle year, make, model and engine. On the customer database I have fields for year, make model and engine. What I would like to know, is there a way that when I click on MAKE that only the makes of cars that were produced for a certain year are displayed instead of all the makes. Then when I click on MODEL only the models for that make and year are displayed and finally when I click on ENGINE only the engines for the model and make of that year are displayed? I'm sure there must be a way to do this and any help would be greatly appreciated. Thanks

Edited October 26, 2006 by Guest

[jteich]

Like this?

-Jens

cars-demo.zip