selecting record

[lendi...@gmail.com]

I have an Purchase request record such as :
PRno Item qty recordnumber
001 AAA 10 1
001 BBB 20 2
001 CCC 15 3

And I have a Purchase order table which the record is taking from Purchase request record. My problem is I can't select on of those records. For example when I choose the 2 and next entry I choose record number 3. the value is still appearing the record number 2.
Can't anyone can help ?

thanks

[Sean H]

Little unsure exactly what you're doing. Is this a browse or some other
code? Is the DB SQL or TPS
Really need a little more info


Sean H

[lendi...@gmail.com]

it is sql server database..and I try to make the field prno and item as primary key but it still can't work..

thanks

[Shandin]

1. In SQL you must have unique identification for every record, I'm
not sure have you acomplished this?
2. About your problem:
Queue in browse list is filled with data from table in db (of course).
In record buffer (for example cus:record) are the values from last
accessed record from table db; ussually it is not the value which is
last selected in browse list.
But good thing is that unique "id" field (which is in primary key) of
the selected item has correct value.
Bad thing is that other fields have not correct values (for example
cus:address, cus:name in customer table).
Here is what you have to do:
- make cus:address and cus:name hot fields
- if this doesn't help: in embed point "new selection, after" put this
code:
get(browse:queue, choice(?List))
cus:address = brw1.Q.cus:address
cus:name = brw1.Q.cus:name

This is from TPS point of view. In addition in SQL world you must use
(in a table schematic) primary key I think.

Hope this helps.
Zoran.