Add field from another Table.

rranjanerp · **Posted:** Wed Apr 11, 2012 11:24 am

I have to display a field named inventory in the Indent Line. The main table used is indent line but the Inventory value is present in another table named : ITEM. How can i use that Inventory value from Item table in the Indent Line.? plz suggest ? same problem with main table indent line & the value of field which i have to use heere is available in the other table named : Value entry. field name : Cost per unit. how to display cost per unit in indent line..i guesed i m lacking in checking the primary keys , but which one to make primary ? & how to select it from C/al symbol menu..plz .describe..

Thanks

Rajeev

mohana_cse06 · **Posted:** Wed Apr 11, 2012 11:33 am

Can you tell us what did you try till now?

David Singleton · **Posted:** Wed Apr 11, 2012 11:56 am

rranjanerp wrote:

I have to display a field named inventory in the Indent Line. The main table used is indent line but the Inventory value is present in another table named : ITEM. How can i use that Inventory value from Item table in the Indent Line.? plz suggest ? same problem with main table indent line & the value of field which i have to use heere is available in the other table named : Value entry. field name : Cost per unit. how to display cost per unit in indent line..i guesed i m lacking in checking the primary keys , but which one to make primary ? & how to select it from C/al symbol menu..plz .describe..

Thanks

Rajeev

Try something like

Code: Select all

IF Item.get("item No.") then begin
  item.calcfields(inventory);
end else
  clear(item);

Message('Inventory value is %1',item.inventory);

Resender · **Posted:** Thu Apr 12, 2012 3:04 pm

using a calcfield seems logical in this situation

David Singleton · **Posted:** Thu Apr 12, 2012 3:24 pm

Resender wrote:

using a calcfield seems logical in this situation

Yes definitely a good option.

rranjanerp · **Posted:** Fri Apr 13, 2012 7:33 am

THANKS A LOT ..

IT WORKS FINE..I WAS USING SumIndex...

mibuso.com

Add field from another Table.

Who is online