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.

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?

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

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

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

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?

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.

Sent as a private topic