Relationship ERROR interferes with other fields in portal

October 6, 200619 yr

Hi,

I am witnessing a weird error that may be a Filemaker glitch.

Setup: two tables, one is a parent relationship. The child has a container with a document in it. This table has 2 occurances related to different keys on the parent. One relationship is one to one. The other relationship is one to many.

Basically I have one field for a report and another field for an invoice. The report is a word file and the invoice is PDF. Each record may only have one report, however each invoice will have many records.

If there is only a PDF, the PDF is properly referenced. However if there is both a PDF and a word file, the PDF field is wrong. It opens up a random file.

I tried creating a separate TO for the Parent, one for the word files and one for the PDF's but the result was the same.

Perhaps the word file locks the record and keeps the other TO from connecting to a different record of the same table?

I dunno, i tried searching for others with the same problem with no luck.

Thanks for any insight!

matt