11th March 2005, 11:43 AM
|
|
Member
|
|
Join Date: Jan 1970
Posts: 4,415
|
|
Duritz,
You are correct.
To fix this issue, open up the access query in design mode:
Right click the relationship (join line between the two tables) and select join properties. Then select show ALL records from table race, and only matching records from table horse. That way if there is no matching horse data, Alinghi won't be missing from the query, only the comments field will be blank.
|