How to Add a data in a field

mbskapil

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

garak

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

bbrown

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.