I thinks this is a case function

[rezdragon]

ok here is what im doing. Im working on a datebase that is for entering types of vehicles.

there is a year,, no problem

there is a make.. again no problem

but i want the model field to only have the certain makes available

so say i type in chevy i only want chevy models availble in the model field or if i type in dodge i only want to be able to pick from dodges.

Any Ideas?

[Zero Tolerence]

This should show you what your trying to do.

Edited January 4, 2006 by Guest
Removed bad file.

[rezdragon]

thank you ,,, but this is not exactly what im talking about. though this works to a degree. i only want them to be able to choose ONLY chevy model or ford model according to the make, so say i choose ford i can only pick models that relate to ford.

[Zero Tolerence]

Sorry, I'm dumb and screwed up my relation :

example.fp7.zip

[rezdragon]

awsome that is perfect .. thank you very much

[rezdragon]

ok here is something i just realized,, as i add records to that, the records all display the same information,,, any ideas as to why what was entered for like record one is not what stays when i enter record 2

[Kent Searight]

I think what you're referring to is how you're limited in choices as you add records. Zero's example just shows the basics of how to get your conditional lists. In your real world application you'll likely want a table already populated with data of makes, models, years, etc. to relate to for your conditional values. The alternative would be to allow manual entry of the fields to allow list building.

Hope this answers your question.

Edited January 7, 2006 by Guest