Add field from another Table.

Comments

• mohana_cse06 Member Posts: 5,503

  2012-04-11

  Can you tell us what did you try till now?

  
  -Mohana
  http://mohana-dynamicsnav.blogspot.in/
  https://www.facebook.com/MohanaDynamicsNav

  0
• David_Singleton Member Posts: 5,479

  2012-04-11

  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

  IF Item.get("item No.") then begin
    item.calcfields(inventory);
  end else
    clear(item);
  
  Message('Inventory value is %1',item.inventory);
  

  David Singleton
  

  0
• Resender Member Posts: 119

  2012-04-12

  using a calcfield seems logical in this situation

  0
• David_Singleton Member Posts: 5,479

  2012-04-12

  Resender wrote:

  using a calcfield seems logical in this situation

  
  Yes definitely a good option.

  David Singleton
  

  0
• rranjanerp Member Posts: 70

  2012-04-13

  THANKS A LOT ..
  
  IT WORKS FINE..I WAS USING SumIndex...

  0