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.

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