What is the exact relationship you have made?
You should have an Invoice table with an InvoiceId. This is a number field with auto enter serial value.
This field should be related to an InvoiceIdFk (Foreign Key) field that is a number field in the Line Items table.
This line items table should also have it's own ID field that's a number field with auto enter serial value. But this field should not be involved in the relationship.
This relationship should be defined as to "Allow the creation of records" on the Line items side of the relationship.
Then you have a layout based on the Invoice table and a portal based on the Line items table.
And you should have no problems.
Maybe verify your actual date in the line items table, to make sure line items are having he correct Invoice ID in the InvoiceIdFk field.
Also check to see if you don't accidentally have a white font colour an a white background.
Wouldn't be the first time :)
Hi thanks for a swift response.
I have included my db file so you can see if there are any descrepancies in my set up.
I have checked everything identified in your post, which thankfully were already in place (so I'm not going mad!!), but still no change. Your eyes may spot something that I'm not seeing. Thanks for your time.
I don't see any attachement.
If you want you can mail it to me, I'll PM you my adress.
Sorry, will email it direct to you...