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