How to Add a data in a field

mbskapil
mbskapil Member Posts: 43
edited 2006-07-08 in NAV/Navision Classic Client
Hi All
In a "Bin Content" Table I added a field called Item Description & there are 1000 odd entries in that table already ,I want to add their respective description as well.
Please help me out.
Thanks in Advance

Comments

  • garak
    garak Member Posts: 3,263
    Why you need the Item Description in this Table? For Reporting?

    An easy way to add the item description is to use an calcfield. ItemDescription Fieldclass FlowField CalcFormula Lookup(Item.Description WHERE (No.=FIELD(Item No.)))

    Editable = No.

    But this is not an good solution, if there are many datas in this Table <- not an good performance. So its better, when you need the Item Description for reporting, Dataport or in Fom to use an Variable of table 27 and use the Description from there.

    Regards
    Do you make it right, it works too!
  • bbrown
    bbrown Member Posts: 3,268
    You could also put a function on the "Bin Content" table that returned the Item's description. Don't put an Item Description field in the "Bin Content" table.
    There are no bugs - only undocumented features.

Categories