I have a database of collector cars owned by a specific member. Each car has a unique ID called the dash_number. I have created a database form where the member/owner CREATES a database entry of the car he owns. What I am looking for is how to allow that member to retrieve JUST HIS ENTRY in order to update it? I created a second database form with just owner email and the dash_number connected to the database and a submit button.
After connecting the button to the dataset and scrolling to bottom "link connects to" all I see is:
My thinking was to use this front end as the query to get the correct database entry onto the original form for update. How do I do this?
Should I use a copy of the Original Input Form instead and add an additonal button for "GET" to retrieve the items and then have another button for "Save Changes"? And if so, would they fill in the email and dash_no and click on Get? This is how it is currently being done with an Informix database backend on the old website.