Re: Dev 2000 Forms ? part 2
Date: 1996/09/16
Message-ID: <51jg09$9k0_at_pheidippides.axion.bt.co.uk>#1/1
Can I just mention that I had all manner of wierd and wonderful things
happen to my form when I had When-Validate-Item trigger on list items -
one of the ugliest problems was updating some table columns with the
rowid of the current record!!
So, just a little warning to be careful with that particular trigger on
list boxes.
:-)
>Set up a When-Validate-Item trigger in the first item, and in this
>trigger, set the second item value to itself:
> :blk.second_item := :blk.secon_item;
>This forces Forms to re-run validation on the second item when you
>leave the block or commit. Also, depending on the value selected in
>the first item, change the query of the record group associated with
>the LOV (on the second item) with a Populate_Group_With_Query function.
>
>On the second item, set up an LOV with the states/countries
>validation, and be sure to set 'LOV for validation' to true.
>
>Not sure if all this will work, but I believe it should.
>
>Good luck,
>Steve Cosner
>
>
>
-- Bev Williams, Contractor, BT Labs, Martlesham Heath, Ipswich. Tel : +01473 642891 Fax : +01473 637313Received on Mon Sep 16 1996 - 00:00:00 CEST