Crazy Records.

[pvivacqua]

I have two databases that are related to each other through a calculation field set to the value of 1 on both databases.

When a user pushes a button on database "A" the following occurs:

- A external script on Database "B" is triggered to create a new record on database "B".

- Information from Database "A" is inserted on Database "B".

- The user is sent to Database "C".

The problem is that this routine occurs around 1000+ times a day, most of the time it works fine but sometimes, without a reason, when the user pushes the button on Database "A" the record on Database "B" is not created and the scripts jumps straight to the Database "C".

I wanted to some help to find out how to eliminate this problem.

I also would like some help in creating a script that would make sure the record was created before sending the user to Database "C" as a safety net.

thanks in advance

[ernst]

pvivacqua said:I wanted to some help to find out how to eliminate this problem.

Could it be that database B is in Find or Preview mode when this happens?

Ernst.

[pvivacqua]

Ernst,

Not really, I have script steps that take care of that by entering BROWSE MODE and going to the right Layout.

[ernst]

Is the record created with the 'New Record' scripts step?

Or in a portal with a relation with 'Allow creation of new records'?

If it's via a portal, then a 0 records found in database B could also be the culprit.

I do not recall Filemaker behaving in the manner you describe, that's why I'd look for thing like this.

Ernst

[pvivacqua]

The record created with the 'New Record' scripts step.

[ernst]

You could store the amount of records in database B with status(CurrentRecordCount) in a global before and after the new record gets created to checkif the creation was succesfull.

This methode could go wrong in a multiuser environment though.

Wonder if anybody else has ever seen this phenomena. What Filemaker version and platform are you using? And is it a multi user (networked) setup?

Ernst.