Data from related table not showing in field on report form
I'm new at FM, so this might be some silly mistake I'm doing. FMP-Advanced 11 on mac Os X.
I have a table [report] that my report form is based on that is linked to three other tables via a dual key of ID-Nr field and a Name field.
When I place a field from the related tables in the body of the report, only one of the tables shows data.
I checked the relationship settings and fields, everything seems the same between the three, yet 2 tables do not "produce" visible data in the filed on the sub-summary list view/report. Sort order does not seem to matter either.
Any suggestions where the culprit may be?
Thanks in advance, I'd appreciate any help...