Hi,

I have the following two tables:

ACCOUNT(ACC_NUM, ACC_DESCRIPTION)
JOURNAL_ENTRY(JE_ID, ACC_NUM, AMOUNT)

I want to use an IB_GRID for editing/inserting records into the
JOURNAL_ENTRY table, but like to have a column that shows the
ACC_DESCRIPTION field as well as soon as the users types in the ACC_NUM.

Currently I have a TIB_Query with SQL: \

select j.*, a.ACC_DESCRIPTION from JOURNAL_ENTRY j, ACCOUNT a where
j.ACC_NUM = a.ACC_NUM

Displaying the above query in an IB_Grid works fine, but I am unable to
edit/insert records. Did some research and found that when setting the
KeyRelation option to JOURNAL_ENTRY I can edit/insert in the grid, but my
problem is this:

How can I have the above query/grid combo behave in insert mode so that when
the user enters the ACC_NUM that the ACC_DESCRIPTION field automatically
gets updated while still in Insert mode ? Can this be done in a grid ?

I use a lookupcombo in the grid to access the ACC_NUM field.

Thanks in advance for any advice.

Beyers

This is an email from CS Holdings. It is confidential to the ordinary user of the email address
to which it is addressed and may contain copyright and/or legally privileged information. No one
else may read, print, store, copy, forward or act in reliance upon all or any part of it or its
attachments. If you received this email in error please notify its sender.