Thanks for getting back to me Daemon.
I can't really do it that way as the queries could be different every time.
A constructed query might look like this:
At which point I can use the Record Id to delete the field as I have the database set not to allow duplicates on this field.
SELECT Record_Id, Colleague, Employee_Number, Cost_Centre, Amount FROM Incentives WHERE Amount >= 2000000 ORDER BY Record_Id DESC
But a query could also look like this:
At which point I have no way of allowing the deletion of one of the records as Record_Id is not present.
SELECT Colleague, Employee_Number, Cost_Centre, Amount FROM Incentives WHERE Amount >= 2000000 ORDER BY Employee_Number DESC
I know you said to use a hidden field but for each record? Seems a bit overkill as there could be thousands of records brought back at a time. I could query Record_ID regardless of what the user asks for, and just display what the user asks for, but the re-coding will take me ages, just wanted to know if there were any shortcuts you could think of.