F45: LOV for validation updates all my records!

[Quoted] [Quoted] 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.

[Quoted] 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
===============================================================