ok chuck let me give you more info

i have 2 records i am dealing with at this moment in file #1i will insert data from 1st record into a column in the 2nd file

then i will go to 2nd record in file #1 and i want it to see there is data in 1st column in file #2 and insert data into 2nd column

etc.upto 10 times if needed

I hope that helps

Dean

[This message has been edited by MDPRES (edited December 28, 2000).]

Chuck heres what my script looks like now.

When I run it the 1st time it works fine, the 2nd time around when I click the button it replaces the data that is already in the 1st field of the 2nd file it is ignoring the else steps.Am I not understanding the true & false of

You just need to have a way for FileMaker to be able to tell which script you want to run.

If [ Criteria01 ]

quote:

---

Originally posted by MDPRES:

it replaces the data that is already in the 1st field of the 2nd file it is ignoring the else steps.

---

I don't understand what you mean by this. Do you mean that the data in field 1 in the related file is changing? And that you don't expect it to be doing that? Is it changing after you run the script the first time and that's breaking it when you try it a second time? Could it be that the scripts you are running based on the If statements is the cause?

BTW, use the Reply button to give more information. Don't edit the original post and delete what was there, since that gives a handy reference history to the topic.

The Reply button is the one that looks like a document with a red arrow pointed to the right.

Chuck

quote:

---

Originally posted by Chuck:

I don't understand what you mean by this. Do you mean that the data in field 1 in the related file is changing? And that you don't expect it to be doing that? Is it changing after you run the script the first time and that's breaking it when you try it a second time? Could it be that the scripts you are running based on the If statements is the cause?

BTW, use the Reply button to give more information. Don't edit the original post and delete what was there, since that gives a handy reference history to the topic.

The Reply button is the one that looks like a document with a red arrow pointed to the right.

Chuck

---

OK I have up to 10 records at any one given time to deal with in file #1 which consists of a number.

I have 10 possible columns in file #2 that I want to insert a number from file #1.

Example:Number1234 in file #1 1st record would go in 1st column in file # 2.Then 4567 in file #1 2nd record would go in 2nd column in file #2.

It would be a progressive process if 1st column has a number then go to 2nd column if 2nd column has a number go to 3rd column etc.

Dean