AnsweredAssumed Answered

Relationship for irrigation valves doesn't work!

Question asked by mjroberson on Aug 19, 2013
Latest reply on Aug 19, 2013 by philmodjunk

Title

Relationship for irrigation valves doesn't work!

Post

     Hi All,

      

     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.

      

     thanks

      

Outcomes