Find Like Date Two different Files

[agaperrk]

I am using FM 5.5 I need to find the same records in two different files.

When I use the Script I created it just keeps looping to infinity.

I have records with a select checkbox in one record, the same checkbox in the second file,

I can do the finds seperatly but when I try to implement them in a script it just loops.

Thanks in advance.

[AudioFreak]

Hi,

Create a relationship between the two fields you are doing the finds on. Then create a script and use the step Go To Related Record. If you need more explanation let me know.

Michael

[agaperrk]

I already have a relationship and I can get them to go to individual records of what I find, I would like to find the same list so i can print or view a group of records.

[AudioFreak]

If you can find the records you want to print then you have most of it.

"I would like to find the same list so i can print or view a group of records."

Are you trying to print one record per page or multiple records on one page? I guess that would explain why you are using a loop if it's the 1st.

Could you post a copy of the script you are using so we can figure out why it is stuck in the loop?

Michael

[agaperrk]

The Script, there are two files one is student and the other is forms

I have a field that is called select which resides on the forms file, I have put it on the student file list layout.

the script start with

perform find(restore, replace)

Go to layout list

perform Script (external script forms find mark)

the find just finds all the yes's in the select field

I use a check box

When I go do the finds individually I can get it to work, when I try to automate it, it just loops.

[AudioFreak]

What does the external script do? Obviously that is where the loop is contained.

Anyway you can post a copy of the file? Would make this much easier.

Michael

[agaperrk]

The Script goes to the forms table and States

Perform Find (restore,) the find criteria is looking for the check in the checkbox, Then goes to a list layout.

[AudioFreak]

I still don't see a loop. Or how you are getting stuck in a loop. A script that performs a find and then calls another find script in another file isn't going to "Loop".

Are you getting a "No records match this find request" error? If so, is it in the First script or the External Script?

Is that ALL of both scripts?

One thing you can try yourself is insert Pause Steps(eg...right before a find is performed, after a sort....etc) in both of the scripts to try and see where the problem might be. You can always remove them after you get it working.

BTW IF you have access to the Developer Version, you can use the Script Debugger Instead of the pauses.

Michael

[agaperrk]

Yes I will give that a try,

I do not have many steps and there is no reason to loop. I get no error it just give the command symbol over and over.

I will try the debugger.

[agaperrk]

When I took the steps one by one, the problem occurred when the script tried to switch files, when it went to open the new file and Run it. I change the way it open the file and I will have to live with it.

Thanks for the help.