Hi,

Sorry, I know it's bad form to keep replying to my own posts...

to validate the data received, I have done a regular call with sql...

select ID, TrailerID, Received, Tyre1, Tyre2, Tyre3, Tyre4, Tyre5, Tyre6

from Trailers

where TrailerID = '5126'

and Received > '1 January 2014'

order by ID desc

I only have one record...

IDTrailerIDReceivedTyre1Tyre2Tyre3Tyre4Tyre5Tyre6

4486951262014-02-11 12:36:41.9872726LO048S8873K346858296Lo524K

I should only be displaying a record if there is a previous record with something in the tyres.

Thanks again for your help.