Re: Developer 2000 forms PKand FK display

Use a POST-QUERY trigger to select the COUNTRY_DESCRIPTION from TABLE A where COUNTRYID = :BLOCKB.COUNTRYID. In BlockB, "display" COUNTRYID on the null canvas.

<ssharma24_at_my-deja.com> wrote in message news:8e4ho3$g06$1_at_nnrp1.deja.com...
> Developer 2000 forms PKand FK display
>
> TABLE A:
> COUNTRYID (primary key) --- any sequence
> COUNTRY_ DESCRIPTION -- ex. United States of America
>
> TABLE B:
> COLUMNA
> COLUMNB
> COUNTRYID (foreign key)
>
> QUESTION:
> Is it possible to show only COUNTRY_ DESCRIPTION field (will NOT be a
> display field. It has to be a field with a LOV behined it, so it has to
> be a text field) without showing COUNTRYID in the block based on TABLE
> B. I have tried it without any succes. Could you please tell me what
> triggers need to be used to accomplish this or what are the steps to do
> it.
> Also, COUNTRYID will be a required (not null) field.
>
> Thanks for your help.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Apr 26 2000 - 00:00:00 CEST