Jump to content

Crazy Records.

This topic is 7567 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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.


Link to comment
Share on other sites

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?


Link to comment
Share on other sites

This topic is 7567 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.