I have a productivity query that pulls from 9 tables. I've established
common relationships between all the tables. For some reason the query does
not return any info. Any suggestions as to what I'm doing wrong?
If you're using the default INNER JOIN then you will only see results if there
is matching data in every single one of the nine tables. A nine-table join
query would be unusual (except perhaps as the basis for a Report); it's almost
certainly not going to be updateable if that's what you expect!
If there are tables which might have no matching data, select the join line to
that table in the Query and select option 2 or 3 - "show all data in <table1>
and matching data in <table2>". The fields in the missing-data table will just
be NULL.