Lookup only works sometimes

[Oyseka]

:) Hi, I have a database that I put in three years ago, originally designed in FM8. It has worked fine until recently when it started missing the dates in the line items for certain items in the invoice portal. It doesn't happen all the time and is generally the first or second portal row in the invoice. The date is defined as a lookup field from the invoice table and the relationship is based on the invoice number.

Any ideas why this should happen.

Thanks in advance

[bcooney]

Can you post a clone of the file? Is the InvoiceID an auto-enter serial or a calculated key? Do you allow new records to be created directly in the portal or is this scripted? Why not an auto-entered calc field? Why have an invoice line item date field at all--can't you just relate up to the invoice for the invoice date?