Crikey, it's taken me over six months to get it right! :wink:

1. Create seperate files

a. containing results data
b. containing race field data
c. containing race details (name rest dist etc).
d. containing previous form

2. Create a relationships or keys that link them all.
E.G.
DATE+RACENUMBER+TAB NUMBER
DATE+TRACK+RACE NUMBER
HORSE+HORSE
etc.
Link them all and create a master file to lookup and do testing.

There are better ways, but this is how I did it coz I was new to databases in general.
The bottom line is the way I've done it is far from how a professional would do it, and it is very space hungry, BUT it works, so I'm happy.

[ This Message was edited by: Chrome Prince on 2003-09-05 20:11 ]