right, deleted my last post.. think is is more down to the point!!!

got every table sorted so far, just one stupid relation.. I have to link the results of a horse race to the horse but cannot figure out how!!!

I have a table listing all the horses (names, dob, value colour) but need to create a table to list what place the horses finish during the 6 annual races - I tried to create a table with (date, race name, place name, 1st, 2nd, 3rd etc) so I can type in which horse finishes where for each race and then AaRrGgHh cannot work out how to link it!

I know I probably need more tables but Its starting to annoy me.. any suggestions would be greatly appreciated!!

the db can be found at http://www.pokernuts.co.uk/access/server.mdb (200k) and I have attached a picture of what I have so far (relationship wise)

Please help :(

AaRrGgHh

I see you ignored the advice given on the thread you deleted!

Since I'm feeling generous, here's a better way of doing it. Note the relationships of the tables, and see the sample query that shows how to pull it all together.

It's not a great idea to put the lookups at a table level as it can get in the way later. It's better to do this in a form with a combo box or list box.

cheers for this.. I didnt mean to ignore the othe posts just thought it would be easier to answer my question if I refined it in one post!!

just hope I can figure out how to use it now :D

In the future, leave your posts so that people can see the entire thread. It is really annoying to waste time considering someone's problem only to find out that someone else already made the same suggestion. You are quite lucky that neileg was feeling generous.