I have a main table, CLIENTS connected to client-JOB INFORMATION via Client ID. client_JOB INFORMATION is connected to LETTERS via job ID.
I can't see any info from Jobs or Clients on my letter layout. I can't enter information into the jobs or client fields either.
I have the same relationship going on with INVOICES and I can access my Job and Client info fine.
Any ideas as to what I am doing wrong?
FMP 10 Advanced Mac 10.6.2
You may need to use a second table occurrence… Maybe this will help: http://forum-en.filemaker.com/t5/Using-FileMaker-Pro/Can-a-portal-contain-data-from-two-tables/td-p/58404
Can you post an image of this section of the relationship graph?