I've only been able to do this one way. I don't have the app in front of me, so just going by memory. Create a single-table view of the table using a variable, such as: set var vID INT create view vTable as select * from Table where id = (.vID) After you select the dropdown search parameter, you do a property table vTable 'refresh' Just not sure how it works with adding a row. Haven't tried that! Karen -----Original Message----- From: James Burroughs <[email protected]> To: [email protected] Sent: Wed, Jan 26, 2022 8:54 pm 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/1692724494.2216555.1643300550162%40mail.yahoo.com.
