make-table query

[3PS]

Hi everyone- have a specific issue how to deal with a "make-table query", that makes a new table out of records from 2 other tables. I sort all records by the field, f.ex. projectID, and if I do not have any records for a specific projectID in one of the 2 tables, my new table, created by my "make-table query", will not contain calculated records from any of the 2 tables. Am I dealing with null-values or am I facing another problem?
Regards 3PS Ole Roskilde Denmark.

[Rainlover]

Copy and change the the name of the Make table to new renamed SELECT Query.

View in Data sheet. Can you see any records. If not your relationships may be incorrect.

[3PS]

Hi Rainlower- many thanks, I changed the relationships and found the the right way- problem solved regards 3PS