Forms Newbie question - help please

Hello everyone.
[Quoted] Could someone tell me the best way to do this.....

Here's the fields of concern in the COMPANYDIR table: COID
CONAME
BILLTOCOID (fk to coid)

Here's exactly what I've done....

Created an additional Block (BILLTOBLOCK) that consists of BILLTOCOID and CONAME
[Quoted] [Quoted] There's a relationship: BILLTOBLOCK.BILLTOCOID = COMPANYDIR.COID on the master block.
[Quoted] [Quoted] I am only displaying the BILLTOBLOCK.CONAME on the canvas

I have created an LOV (LOV_BT) based on the Query: Select COID, CONAME FROM COMPANYDIR.
[Quoted] [Quoted] Column Mapping: COID mapped to BILLTOBLOCK.BILLTOCOID

                              CONAME mapped to BILLTOBLOCK.CONAME

The BILLTOBLOCK.CONAME properties:
List of Values = LOV_BT
Validate from list = Yes

I want the user to be able to change the BILLTOBLOCK.CONAME and have [Quoted] BILLTOCOID updated with the COID in the same record.

Am I doing something wrong, or is there an easier way? Thanks very much.
Lesley Received on Tue Dec 12 2000 - 17:53:57 CET