OK see what I have got is this:

First table, into which I paste all my data of races gone by. Essentially, it contains columns like horse name, weight, distance, going, rating etc and heaps others. Basically, for a meeting gone by a race might look like the example below (race example)

So then I paste that info, plus other columns containing other equally boring stuff, into the Access DB, so then basically there are heaps of individual lines of info.

Then when I query for an upcoming race it will query by the horse name and return all that info, see.

What I need is to have another table, lined to the first one by horse name, where I can add other info like a general comment about the horse (timeform style) and age, breeding, prizemoney, these kind of details that wouldn't be included in the race example above. Then when I query in excel it can query both tables and return the different sets of info.

Thanks.

Attached Files

race example.xls (16.5 KB, 641 views)