Developer 2000 forms text item vs display items

Developer 2000 forms text item vs display items:

TABLE A:
COUNTRYID (primary key) --- any sequence COUNTRY_ DESCRIPTION -- ex. United States of America

TABLE B:
COLUMNA
COLUMNB
COUNTRYID (foreign key)

I want to show only COUNTRY_ DESCRIPTION field (will NOT be a display field.
It has to be a field with a LOV behind it, so it has to be a text field)
without showing COUNTRYID in the block based on TABLE B. Also, COUNTRYID and COUNTRY_ DESCRIPTION both will be required (not null) fields and will be getting populated through a LOV at te same instant.
And , I have done the above portion successfully.

Problem:

COUNTRY_ DESCRIPTION doesn’t show up when we query the block (it is saved in the database though). This can be rectified by writing a post_querry trigger on the block.
But, COUNTRY_ DESCRIPTION is a text field on our block...so when the post query trigger fetches value into it..the form thinks that the field has been updated and the form has changed..so it asks me whether I want to save the changed records or not (although, I haven't modified it). The solution to this would be to declare countryid as a display field. But then I won't be able to use LOV behind it, because display columns don't have LOV option...
Any ideas….
Thanks..

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Apr 28 2000 - 00:00:00 CEST