Relationship for irrigation valves doesn't work!
I want my database to track upgrades to features on individual valves in an irrigation system. Items that I want to track include;
Table 1. IC Irrigation controller (make, model, start and end dates)
Table 2. VS Valve stations (from 1 to X valves, valve type, flow rate, duration, etc).
Table 3. uVS Valve station upgrades (same 1 to X as in Table 2, valve type, flow rate, duration, etc).
The valve stations in Table 3 (uVS), are the same as in Table 2 (VS).
My approach is to make the three tables and to enter data in the following order table 1, 2, 3.
However, I can't seem to get the valve stations entered in Table 2 to show up in Table 3.
I've set the relationship between the two valve station fields as equal and allow the creation of valves in table 2 to create valves in table 3 but when I enter data in table 2 it does not show up in table 3!
However, when I create a valve in table 3 it does show up in table 2!
Please advise me as to what I can try to fix this issue.