Loops and record creation

[Andrew_Hobson]

Hello,

Here is what I need to do.

Perform a search to find my Participants

Loop thru the selected records from the Participants table

In the Loop create a record in the table Temporary

Based on criterias in a multivalued field in the Table Participants (Conditional if)

End Loop if the end of file Participants in reached

Is this technically possible with FileMaker.

[IdealData]

You have described exactly how it is done so you clearly have a good understanding of the procedure - what's stopping you writing the script?

Your plan is fine - is there anything specific you need clarity on?

[Andrew_Hobson]

Hi,

I am unsure how FileMaker works.

I must go into search mode for the table Participants.

Then loop thru the selected records of table Participants.

But in the loop I need to create records for another table that has no relations to Participants.

So as you suggest, this is possible? Could you please provide me with an example ? Because I don't understand...

Thanks

[The Big Bear]

Andrew

this should give you an idea for your needs.

Enter Find mode

set field(targetfield; calculated results)

preform find

goto record (First)

loop

set field (targetfield; calculated results)

set field (targetfiled; calculated results)

goto Record (next) "Check box exit after last"

end loop

Make sure you check the box [color:red]exit after last or you will be stuck in the loop.

Hope this helps

Lionel

[efen]

The OP wants to create records in another table. The script steps you have given will not do that.

[efen]

Attached is a file with a simple find script that will create records in another table.

I assume that your other table is is the same file.

Or is the other table in a separate file and importing/exporting your found records may be a better option.

Is this the best method for what you want to accomplish?

[Andrew_Hobson]

Unfortunately, I'm not able to download your example file.

I get an error message that the file is missing!

Would you be OK to send it direct ton my Email adress?

Thanks. Andrew.

[efen]

Sent as a private topic