Relationships

[bloodycape]

I have 4 tables:

Table 1 Table 2 Table 3 Table 4
(16 entries) (8 entries) (4 entries) (1 entry)
case_nmbr case_nmbr case_nmbr case_nmbr
case_date case_action case_fees case_stat

I want to put data from the case_date, case_action, case_fees, case_stat fields in a report. Since they're in different tables I create a relationship between these tables based on the case_nmbr field. The problem is when i generate the report I get no output; if I use only 3 of the 4 tables I get some output, 2 of 4 some more, etc. I know what is happening, since each table has a different number of entries, only the entries with the same case number in both tables is displayed. The more tables in the relationship = the fewer common entries.

I don't want this to happen, i want to output all the entries in table 1 and if there is not a corrisponding entry in the other tables just leave that field blank on the report.

I apparently don't understand relationships as well I i thought. I didn't this that they did anything more than link common data.

I am not using the case_nmbr as a filter, but that seems to be what is happening.

If anybody has any clue what is going on, please let me know.

 

[Sammy B]

Look at the type of relationships you have created. You can choose from 3 main types. Depending on the type you get different results.

 

[bloodycape]

nice, they seemed to have left that out in my book, and that seems to have solved my problem. Thanks sammy B