In my form, there is two combox.
One is Cust_id and the other is Cust_Name.
The Table Customer has those two index.
So, when click CobCust_id, Set the order to Cust_id and search
whereas Click CobCust_Name, Set the order to Cust_Name and search
Problem: after one search and refresh, click other combox will give a Wrong Reference number.
Cust_id: [L606]
Cust_Name: [Mary Ltd.]
When click [Mary Ltd.], will see:
Cust_id: [L606]
Cust_Name: [Mary Ltd.]
+Caroline Pacific+
+Cas... +
......
Which is
not starting at [Mary Ltd.]
Similiar, when fix the Cust_name, the click on CUst_id change quite far from expected!
Why?? I have code:
SELECT CUSTOMER
curCust_Name = Cust_Name
SET ORDER TO Cust_Name
LOCATE FOR Cust_Name = curCust_Name
The weak wait for chance, The strong bid for chance,
The clever notch up chance, but The merciful give you chance.