Karen and Jan, The way I did it before was using variable lookup list boxes and worked well although sometime a little slow although switching to temporary tables solved that issue. I definitely need to look at drag and drop. Thanks for the info, much appreciated. Javier, Javier Valencia, PE [email protected] O: 913-829-0888 C: 913-915-3137 From: 'Karen Tellef' via RBASE-L [mailto:[email protected]] Sent: Friday, September 25, 2020 9:07 AM To: [email protected] Subject: Re: [RBASE-L] - Using Variable Lookup List to move data between tables Javier: Have you looked at the "drag and drop"? It's on the right-click properties of list views. You enable it first, then do the EEPs. I've done it once or twice, I'd have to look in my notes where I might've kept examples of how I did mine. So I can't give you examples without looking. Karen -----Original Message----- From: [email protected] To: [email protected] Sent: Thu, Sep 24, 2020 10:31 pm Subject: [RBASE-L] - Using Variable Lookup List to move data between tables I have an application in which I have to display records from one table (driving_table) and when I click on a record it is moved to a Temporary second table (selected_records) and virtually removed from the driving table (driving_table does not display records already present in the selected_records table) so it cannot be selected again. Likewise, when I click on a record on the selected _records table, it is removed from the selected_records table and the driving_table display that record again since it is no longer in the selected_records table and thus it is available for re-selection if needed. Hopefully this makes sense. In the past I have used two Variable Lookup List boxes, the first with the driving_table data and the second with the selected_records data and use "on click" to move record back and forth. Once the desired records are selected I merge them into one combined record and store it in a separate table. Is this still the preferred way to do this or is there a better approach? I actually would prefer using two grids but I have not tried this approach. Any suggestions or simpler/easier approach that you might have will be appreciated. Javier, Javier Valencia, PE [email protected] O: 913-829-0888 C: 913-915-3137 -- 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/!%26!AAAAAAAAAAAYAAAAAAAAAO1ueGVb5zRMiwo7hebUe7jCgAAAEAAAAPBnw8jQiQpDqLRYG3Y2WcoBAAAAAA%3D%3D%40vtgonline.com. -- 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/1423684075.601871.1601042830293%40mail.yahoo.com <https://groups.google.com/d/msgid/rbase-l/1423684075.601871.1601042830293%40mail.yahoo.com?utm_medium=email&utm_source=footer> .
-- 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/!%26!AAAAAAAAAAAYAAAAAAAAAO1ueGVb5zRMiwo7hebUe7jCgAAAEAAAAKI4izG6E6hEuwuaL4G8c9sBAAAAAA%3D%3D%40vtgonline.com.
