How to Get the values

subrata.bauri

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?

kriki

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;