Best guess is that the other customer records either do not have a customer ID or the invoice records lack a customer ID that matches. You can test this by copying the customer ID number for a given customer record to the clipboard, then switch to your invoices record, enter find mode and paste the customer ID number into the invoice layout's customer ID number and perform a find to see if you can actually find the invoices that should be appearing in the portal.
All customer records have a customer ID, and customer IDs on the Invoices are selected from a drop-down value list referencing Customers:Customer ID, so they have to be the same. I tested this as you suggested, by copying the Customer ID and performing a find on it in Invoices, and it found an invoice, but still nothing in the portal.
Can you get a screenshot of your relationship graph and the relationship dialog
Odd that it works for one record and not the others. I can think of lots of reasons how you would get no records for all customers, but you get it to work for one customer.
I would assume you have both ID fields defined as the same data type? (That's the most obvious potential issue, but again, why would that work for one customer and not the others?)
I wonder if the file has an indexing problem.
To rebuild the index of a single field:
- Open Manage | Database | Fields and double click the field
- Use either the storage tab or the storage options button to turn off indexing.
- Exit Manage | Database, then return and turn indexing back on.
You can also rebuild all your file's indexes by importing all the data into an empty copy (clone) of your file.
If you have FileMaker 11, you can use Advanced Recovery options to rebuild your file's indexes:
- With the file closed, select Recover from the File Menu.
- Select "Use advanced Options"
- Select only: "Copy File Blocks as-is" and "Rebuild Field Indexes Now".
What's a relationship dialog?
The relationship dialog is what pops up when you double click on the relationship you created between tables.
Bingo! Different data types! The first record worked because the customer ID started with a number, while the others started with letters :)