Strange Script Behavior After Clearing a Field.

[smilemaker]

I hope I'm missing something obvious. I'm working with two database files (eg,A-file and B-file). In A-file (patient information) I have some fields that are used in a B-file script to create or delete B-file records(Representing Invoices). Once the information is entered in the A-file the user hits a button that runs an external scipt in B-file to create the Invoices. This usually seem to work fine.

I also have a "clear" script in the A-file to reset the fields (using set commands). Now, here is the deal. After I use the "clear" script prior to entering new data for more invoices, the B-file script doesn't seem to work the first time. If I activate the script a second time, it works. I'm confused. What is going on?

I apologize if my newbie status to programing is blinding me from the obvious. Thanks for any help.

[Razumovsky]

It is hard to say from what you posted. How are the new records created? Through a portal/relationship? Through a create new records step? Are you using a relationship to set the fields in File B? When you clear the fields, are you accidently clearing the key field that is the target of the A:: relationship?

If you post your scripts, someone could probably help you better.

-Raz