Thanks for the reply, I think the easiest way to describe my database is for me to attach a relationships diagram.
I have been using this mySQL (website display purposes) database with an Access front end (for updating) for a while now and appreciate that I might have to modify it somewhat to enable it to be used.
Initially I would like to pick an event(trial) then select dogs and then update that data to the results table. Once I have got my head round that i can look into it further .
Is this something that I can use dataassist for.
Could you explain further what you meant by join query on the results page.
I am not asking for step by step instructions, a nudge in the right direction would be appreciated.
Many thanks,