create multiple records on submit

[etolpygo]

We are using about 15 FileMaker 4.1 databases as a backend to a website.

One of the databases includes the following fields: reviewer

[Keith M. Davie]

"The problem is, when multiple documents are selected from the list, instead of creating a separate record for each document..."

Hello. I have been confused. Is each document a separate record in a db file? Or does one record hold several documents?

Is the list which is generated from the search a list of records or a list of documents within one record?

You say that FileMaker creates a record which lists all the documents. How are you getting FileMaker to create this record? What command? A -new action tag or a -script action tag? I know you are not using InlineAction as you are using 4.0. Are you using portals?

[etolpygo]

yes, each document is a separate record, but in a different db file, the one that we are running the search from.

to create a new record, we are using the -new action tag

[Simon]

You could have some selections on your form be tokens not fields. Have a -format page that is a redirect. Swap over the tokens into field definitions and create the second record on the second page.

I think

Simon

[Keith M. Davie]

Ok. So when you create the new record, it is a record of the found set of records. And that is what is being displayed.

[etolpygo]

thanks to all who replied, but we have succeeded in writing a fm script that separates the new record with multiple entries in a single field into multiple records !

[Keith M. Davie]

FileMaker is single-threaded in its handling of ScriptMaker scripts. In spite of the claims by FileMaker concerning their cdml -script tag, you are advised to not run single-threaded handled scripts over the multi-user web unless you can come up with a workaround for the problem. This problem has been widely discussed on these forums, esp. the cdml forum. You would be well advised to do a little research on this before you proceed. You are asking for trouble, data loss and disappointed clients.