simple Form/datasheet question

[CK]

Hi
Can anyone help with a quick/simple question which has been driving me round
the bend! I'm procrastinating from doing any real work by trying to sort it
out but clearly not getting anywhere.

Two tables:
1. TableCurriculum with fields: CurrID, CurriculumStatement,
DocumentID,...etc.
2. TableDocuments with fields: DocumentID, DocumentTitle,...etc.
Joined by DocumentID. (Each document can be linked to more than one
curriculumstatement)

the Form (in Datasheet format ) needs to show ALL CurriculumStatements,
whether or not it has a Document linked to it, so I can see at a glance which
Statements have had Documents attached to them and which haven't. Currently
it is showing only those that have been linked to a document.

thanks for your help!
Regards
CK

 

[Allen Browne]

If your form is based on a query that uses both tables, and only shows the
records that have a match in both tables, you need to change the query to
use an outer join.

Details in:
The Query Lost My Records! (Nulls)
at:
http://allenbrowne.com/casu-02.html

 

[Allen Browne]

RIGHT JOIN could be correct.

There are 2 kinds of outer joins: LEFT and RIGHT.
A LEFT join gives all records from Table1, and any matches from Table2;
A RIGHT join gives all records from Table2, and any matches from Table1.
So, these are 2 kinds of outer joins.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

thanks Allen

by changing to the relationship to a one-to-many relationship it seems to
have worked. (Interestingly the query code says "Right Join" not Inner or
Outer join, but it is working)

Best wishes
CK

If your form is based on a query that uses both tables, and only shows the
records that have a match in both tables, you need to change the query to
use an outer join.

Details in:
The Query Lost My Records! (Nulls)
at:
http://allenbrowne.com/casu-02.html

Hi
Can anyone help with a quick/simple question which has been driving me

[quoted text clipped - 20 lines]

Regards
CK