In the definition window (double click on a relationship in the relationship graph): Is 'allow creation of records..' checked? (I don't have an english version of FileMaker Pro here, so the text may differ...)
Thanks, but yes, that is selected.
Actually I went and doubled checked and it wasn't on the services tables. Thanks for the reminder! DOH!
However, as Table 1 record 1 has 2 service records in Table 2 and each one of these services has an asset in Table 3, what I what to show in table 3 is only the asset(s) of the currently selected service from Table 2. At the moment having created a second instance of Table 3, the second portal correctly shows just the records (assets) relating to the Table 2 (Service) record, but only for the first record. If one clicks onto the second or third record in the Table 2 portal, the associated records in table 3 do not change/ get displayed they remain on the records for table 3 that relate to the first record in Table 2.
How does one get the layout to show just the asset (Table 3), of the SELECTED service (Table 2) for the current record (Table 1) - assuming when the User moves to or finds a record in Table 1, the first record in Table 2 is automatically selected when the layout is loaded.
I Have tried using a GoToRelated record script when I click on the Table 2 - Service No Field but this generates an error "this layout cannot display the result"