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?

This should show you what your trying to do.

Edited January 4, 200620 yr by Guest
Removed bad file.

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.

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

example.fp7.zip

awsome that is perfect .. thank you very much

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

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, 200620 yr by Guest