Is it possible to delete found records within a script. I am importing a file into Filemaker that has a header and footer file, I am writing a script to automate this process so that the relevant department can import the record and delete the header and footer.

I can find header and footer files as I have created a field that contains a code taken from the main record, header and footer files have a specific codes within the main record. I have set my script to find all Header and Footer files as there will be up to 20 files imported at once and I want to have a script that searches the whole file and deletes any Header or Footers.

I hope this makes sense (it makes sense in my head but so do the voices )

Any light you can shed on this problem is greatly appreciated.

yes of course,

the Delete All Records script step will delete all records in Current Found Set

So...

after performing find and testing that the found set is existing simply call Delete All records step

Dj

I think Mr DjGoran's answer might be what you need.

But you are talking about deleting *files*? Header and footer files?

Are you storing files in your records, or records in your fields. What will they think of next

Sorry I wasnt ver specific. Header and Footer Records.

I have used DjGorans solutions and it has worked brilliantly.

Many thanks