Very Urgent

[Azhar S]

Master table- ITEM
Detailed table -ORDER

While displaying data in datagrid
instead of displaying the ITEMCODE from Detailed table I'm displaying

ITEMNAME from Master table as per the requirement. Displaying is done

fine but when trying to add new record in a Detailed table which contains

ITEMCODE as foreign key how can I insert new record using

ITEMNAME.

I'm using SQL statement: "select --,--,Itemname from Order,Item where

Order.Itemcode=Item.Itemcode."
This displays ITEMNAME instead of ITEMCODE (so that the user can

easily recognize the item) in a grid which is bound by ADODC control.
How should I add new record in a grid using ITEMNAME as the user

can't remember the ITEMCODE everytime.

I've tried updating using recordset object in beforeupdate event of the grid.
(field values r taken from grid). But as the AllowUpdate option of the grid

will be set to true it's saving the same record twice.

Please suggest a solution for this as soon as possible.

Thanks in advance