problem when using related tables or relationships

[Guest]

Hi. I have a table that is relationed with some other tables. I made this
links with relationships.

I'm having this problem. I wnat to manage issues. Well there's a main table
with the issue name and number. And there's other tree tables, one for dept.
1 other for 2 and other for 3. Some of these tree tables have relationships
with others tables.

When I make a querie using all related queries some of record do not
appeared. I think that tdon't appear because some fields are not filled.

How can I cross this problem? Because come fields are not to be filled and I
need to make report over this querie. Is any way?

Regards,
Marco

 

[Allen Browne]

The 2 issues to watch for here are:
- Use outer joins on your tables;
- In the criteria, use:
Is Null OR (whatever)

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