How to Get the values

subrata.bauri
subrata.bauri Member Posts: 21
edited 2006-06-29 in Navision Attain
Respected sir,


I have 2 tables - Tabel1 and Table2
Table 1 has 2 fields -- Barcode No. and Item Desc.
Table1 is filled with values. Such

Barcode No. Item Desc
123 abc
235 sdf
124 uww


Table2 has 2 fields -- No. and Desc. And only No. field is filled with The Barcode no but not orderly as Table1.


I have to do some thing(coding) that retrieve the values(Item Desc in Desc) .such
IF Barcode= No.
Then Item Desc will be placed in Desc(field) in Table2.

How can I do that?

Comments

  • kriki
    kriki Member, Moderator Posts: 9,121
    I hope I did understand your problem correctly. 
    Table2.RESET;
IF Table2.FIND('-') THEN
  REPEAT
    IF Table1.get(Table2."No.") THEN BEGIN
      Table2Bis := Table2;
      Table2Bis."Descr." := Table1."Item Descr.";
      Table2Bis.MODIFY(FALSE);
    END;
  UNTIL Table2.NEXT = 0;
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Categories