get value with non-primary key field

dhaval

i'm new in navision ,
i want to get data without using primary key.
example:=
table:-service tax entry(str-record variable)
-vendor ledger entry(vle-record variable)
-variable(date-datatype)
(i want 'document date' field from vendor ledger entry through 'party code' and store it in variable)
MyCode:
str.setrange('str.partycode','00012');
if str.find('-') then begin
vle.setrange(vle."vendorno",str."partycode");
variable := vle."documentdate";//<-- not return value
end;

please suggest me right code.

Kishorm

Hi, You need a find('-') for the vle record just after the SETRANGE similar to what you have done for the str record

Kishorm

Hi, You need a find('-') for the vle record just after the SETRANGE similar to what you have done for the str record