Jan, Try putting an ORDER BY in your second listview.
Jan (the other one) -----Original Message----- From: "Jan Barley" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Tue, 13 Oct 2009 10:07:37 -0400 Subject: [RBASE-L] - Variable Lookup Listview Good morning all! I have created a really cool application to reconcile deposits! I am working with a customer that may have one large deposit for a day, but need to fill out several deposit slips to record all checks. I created a form using 2 variable lookup listviews. The first VLL is based on my table invoices and the second is based on a temp table. When the user selects a check, it is appended to the temp table and both listviews are refreshed. The second VLL displays all selected checks and keeps a running total to balance the deposit slip amount. The user just clicks a check number from the left VLL and it appears on the second VLL. If the user right clicks on a check in the second VLL it is removed from the temp table, the second VLL and reappears on the first VLL. Everything works great EXCEPT on the temp table's VLL, the checks appear in a somewhat random order. I issue a PROPERTY table REFRESH 'TRUE' with each click and have tried using a PROPERTY temptable CLOSE , then OPEN, then REFRESH, and it doesn't refresh the list in the order it is appended to the temp table. I have also included PROPERTY VLL REFRESHLIST 'TRUE' after each click, but nothing puts the checks in the order selected. What am I missing??? Thanks! Jan Barley
