Jump to content

I thinks this is a case function


This topic is 5735 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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?

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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 by Guest
Link to comment
Share on other sites

This topic is 5735 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.