Jim I would prefer using DIALOG to get the date then based on date use CHOOSE which would return uniqueID for that row. Then EDIT USING formName WHERE UniqueID = .vUniqueID
If user didn't choose anything then using DIALOG ask if they want to add a row if yes then ENTER USING formName Else exit Buddy -----Original Message----- From: [email protected] <[email protected]> On Behalf Of James Burroughs Sent: Wednesday, January 26, 2022 9:54 PM To: [email protected] Subject: [RBASE-L] - How to navigate to a specific table row and display it on a form I have a form which displays columns from a single row of a table. The user is given the option either to enter a new row or to edit an existing row. If a new row, then a blank form is displayed. If an existing row, then the user selects a row from a drop down list based on a date. My question is how to get the form to display the row that was selected? I've tried the EDIT USING command with a WHERE clause from within an EEP to select the desired row and display the information on the form. This works, but opens a new instance of the form. I'm wondering if there is a better approach. Thanks, Jim Burroughs -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/28f5a21f-85d0-3267-9e30-dd91e86d77c0%40cox.net. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/002601d81377%2471849560%24548dc020%24%40comcast.net.
