Re: F45: LOV for validation updates all my records!

In article <LCTwyDA6MzD4EwxP_at_ahardy.demon.co.uk>, Andy Hardy <aph_at_ahardy.demon.co.uk> writes
>Hi,
>
>I have a form based on a two value table. Each of the two values is
>allowed a set number of distinct values so I use a LOV linked to an RG
>that takes its values from the database.
Not entirely true.. I have the two key fields hidden and populate two description fields as part of a POST-QUERY. These description fields are attacked to the LOVs and have validation on them.

>
>When I execute_query, it would appear that each record is being
>validated during the query (lots of flickering cursor!). When I make a
>change and save it, I get a message that says, in effect, all records
>loaded to the form have been updated (even though none of them appear to
>have changed).
>
>How do I get around this? I only want the validation to be carried out
>for new data entries.
>
>Andy

-- 
Andy Hardy. PGP key available on request
===============================================================