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.