Creating Relationships For 3 Tables
Table 1 fields are Project Name and Site ID Table 2 fields are MS1 Date and MS2 Date Table 3 fields are Pole Name and Cost How do I create the relationships for Table 3 to produce a report with t...
Forum Discussion
Would need to know a bit more about your structure, but in general, you need to get the fields you need to your 'common' table. In this case, everything is somehow tied to Table 2.
So take your fields from Table 1 and get them to table 2. Then from Table 2, take those fields and get them to table 3.
I use the words 'get them' because it will be a lookup field or summary field depending on how all your tables are connected.
------------------------------
Mike Tamoush
------------------------------
So take your fields from Table 1 and get them to table 2. Then from Table 2, take those fields and get them to table 3.
I use the words 'get them' because it will be a lookup field or summary field depending on how all your tables are connected.
------------------------------
Mike Tamoush
------------------------------
Thanks for your help! Any idea what would cause Active Project - MS1 (date field) to be empty. This report comes from Table 3.
------------------------------
Mike Sanders
------------------------------
------------------------------
Mike Sanders
------------------------------