Hi everyone, I have a variable lookup listbox based on a view.
My data looks something like this: Line Invoiceid trucknb servicedate 1 31260 13 2/01/05 2 32134 14 3/15/05 3 31260 14 5/15/05 I want to do further processing when I click on the row: When the variable for the listbox is vtruck (trucknb field) and I click on line 3, vtruck is = 14 but because line 2 also has the same value for trucknb, when I say: select servicedate into vscedt where trucknb = .vtruck this is the record that is processed (vscedt = 3/15/05 instead of 5/15/05). If I change the variable for the listbox to vinvoiceid (invoiceid field) and I pick my record by invoiceid, then when I click on line 3, select servicedate into vscedt where invoiceid = .vinvoiceid, I get 2/01/05 instead of 5/15/05.... Is there a way to identify the unique row that is clicked? TIA, Claudine :)
