Thank you Doug, but it didn’t work.
I tried but when I join (inner, left or right) Table 1 and 2, and run the query, nothing is displayed.
I am guessing that the record from Table 1 is displayed multiple times because it is, as all other records in Table 2, related to the same Name in the Names Table. But I would need it there only once because when creating a report it is (the record from Table 1) in there duplicated as well.
I’ll try to describe this one more time with more details:
-
Table Names contains 1 record
-
Table 1 contains 1 record
-
Table 2 contains 2 records
-
Table Names is in 1:n relationship with Table 1
-
Table Names is in 1:n relationship with Table 2
The records from Table 1 and from Table 2 are entered via form and attributed to John Smith (Table Names).
When I try to create query by adding Table Name, Table 1 and Table 2, records are displayed in two rows:
- John Smith, the only record from Table 1, 1st record from Table 2
- John Smith, the only record from Table 1, 2nd record from Table 2
If in Table 2 I have 5 or 10 or 500 records attributed to John Smith, the record from Table 1 is displayed 5 or 10 or 500 times.
I was hoping to find some solution and that I won’t have to put everything in one Table with 25, or so, fields.
Is there a solution for this?