AnsweredAssumed Answered

Relationships

Question asked by DustFairy on Mar 6, 2015
Latest reply on Mar 7, 2015 by SteveMartino

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

Outcomes