3 Replies Latest reply on Mar 7, 2015 6:09 AM by SteveMartino

    Relationships

    DustFairy

      Title

      Relationships

      Post

      In a database with with Table 1 connected to Tables 2 and 3 with one to many relationships, is it possible to place fields from Table 3 on layouts in Table 2?  

      I am trying to place fields from Units on Layouts based on the Inspection table.  The fields I place on the Inspection layouts always show the same Unit information.  The field data does not change when I change the unit number on the Inspection layout.

      I have tried adding another Unit table occurrence connection __pk Unit to _fk Unit but it doesn't seem to matter.

      Any suggestions from anyone?  

      Screen shot of Rel. Id. attached.

      Screen_Shot_2015-03-06_at_9.59.58_PM.png