Charlene,
Yes I can appreciate that being a problem however, in this case the
field used as the relationship link in the original record was still
there, the record in the related file had gone. From backups I was able
to locate the original missing record for the related file and re create
it and enter the original related field number.
I still can't understand why these records get deleted. Anyway, I have
modified that client's solution so that once the Bank Reconciliation is
completed and correct, a new 'button' then locks all records in the
original and related files from any further modification or deletion.
This will identify if it was the client user who was in some way
contributing to the problem.
Lee Mills
Flora, Charlene wrote:
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
--
