12th March 2005, 07:10 PM
|
|
Member
|
|
Join Date: Jan 1970
Posts: 4,415
|
|
Quote:
|
Originally Posted by Duritz
OK I must be missing the point though.
For an upcoming meeting, say Flemington today, how do I get it to query for all the runners running there at once, so that the results returned are the history's of all runners running there today?
Because if I have all my records of all horses etc in the race database and run that query you sent me, won't that just return me all records of all horses in the DB?
Sorry if this is a nuisance.
|
Not a nuisance Duritz, not at all.
Just import todays race field into the race table, run the query and it will show all past info and comments for horses running today, but not others not running, that's the purpose of the horse relationship. |