Jump to content
Sign in to follow this  

A pop-up list to change record?

Recommended Posts

Hi All

I'm nearing completing my database and I had a couple of queries, though I'm not sure which sub-section is best - anyway, here goes!

We're selling cars and every car when sold needs to have a PDI (pre-delivery inspection).

There's a table for cars and a table for PDI information. Cars have a unique vehicle ID which links the two tables and I have also given the PDIs a unique ID.

We have made the layout so that our mechanics can use an iPad to fill out the form.

MY ISSUE is that they naturally want to use the "vehicle ID" drop-down I have to do a PDI on another car, but of course they're just changing that one ID and linking their info to a different car.

Is there a way that I can make it so there is ONE PDI sheet per car and have the drop-down choose between those records, or must this be done using the search feature?

Many thanks!


Share this post

Link to post
Share on other sites

well you could use a global field to allow your users to select a car and it navigate to that car. you can attach a script trigger to that field and allow it to run a find for you.

That being said, perhaps you should look into changing your navigation somewhat if they keep selecting the wrong thing. Big buttons for NEW and also maybe once a PDI is done, perhaps send them to a layout where they cant edit the fields.

Share this post

Link to post
Share on other sites

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
Sign in to follow this  


Important Information

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