Lee, This can happen if someone has changed the related field data in the original record.
I have this problem with staff changing the EID field of the original table and then contact me that the related table has fields missing data. All I did was enter the original EID field's data into the related table's EID field which called up the missing data. Charlene -----Original Message----- From: FileMaker Pro Discussions [mailto:[EMAIL PROTECTED] On Behalf Of Lee Sent: Monday, February 26, 2007 12:10 AM To: [email protected] Subject: missing data Hi, I know this is not going to sound very obvious but I'll do my best. Recently I've been having a problems with two client's data going missing. For example, a line item record seems to have disappeared, not the record in the primary file. It wasn't a current record being used, in fact it was 6 months old. This has happened on a few occasions. Another client has also suffered this 'trick'. On both occasions it has been a record held in another 'Layout' as I'm using Filemaker 8. The client's have filemaker 8v3 and I've developed both solutions using 8.5 advanced. Each client is running two computers, peer to peer networking. I can find no reason for this happening. When examined, the primary file still has its own data but when searching the line item file using the related link record ID, that record has disappeared from the line item file Another example is when a client was doing a bank reconciliation two line item records from July last year had disappeared, obviously causing this month's reconciliation to be out those two amounts. Has any one else had any similar problems using FM8. I've never struck this before in the 15 years I've been developing solutions for small businesses. I'm struggling to convince the client its not a filemaker issue, when I can't 'see' how it could have occurred. Lee Mills
