Hello All

Here's the dilema:

I am creating an online form with CDML and FileMaker. The form itself accesses three different databases. I tried using scripts to create the proper values in fields in the additional db's to create the relationships so the data would go in no problem.

Didn't work. It wouldn;t properly grab the right record. Caused problems when more than one person was submitting.

The next solution was to create Global fields in the main db and create a script that moves the values to the right places in the other db's. In theory great idea however it seems that I can't post data to global fields from the net. Is this true or am I just loosing my mind.

This is where I'm at now. Any help would be great.

Thank you

The way I have done this is to add the fields needed to the database that the form uses/updates. This can be by means of a calculation or portal (relationship).

Sorry

I should have been more clear. With the first solution I used portals and relationships. The dilema with that is in the portal records you need to create the foreign key in order to put the info in. I am creating a brand new record in all db's. I created a script to put the foreign keys in but for some reason it would create the new record but not leave the record it's on. The form would be a find on the last record and when the form would be filled out it would only update the record.

thanks

Just want to say thanks for all the help

I just figured it out. There was a small problem with my code.

Thanx

Rob