Empty File Related to Main Data File

[grumbachr]

I'm looking for some advice.

Currently I have to work with 2 FM files. One is hosted on FMServer and FM Clients connect to it on our internal network.

There is a 2nd file that is hosted on FMServer Advanced using instant web publishing that is available to the world. The second file is for people to fill out a questionnaire. I take that data from that file export it and import it into the first file. then remove the records from the 2nd file. This is for HIPAA (HIPPA) security reasons.

Would it be possible to setup a file on the external/web server that can be hosted with IWP but all the data goes straight into my main file.

Or would you Pros recommend I do it a different way? I just trying to evaluate my option currently but in my head the empty file feading the main file sounds like it should be easy but I could be fooling myself.

Any advice is greatly appreciated.

[AudioFreak]

I may be totally off base here. But could you not have the users enter the answers into Globals and have a submit button that calls a script in the Main file to import the values from the global fields. The clear all the globals when done.

The submit script could also check to make sure all the questions are filled in using a If Is Empty.

Michael

[grumbachr]

I have thought about that but wont that break if I have more than one person filling out the questionnaire at a time?

[AudioFreak]

That's why you use globals. They are specific to the user and session.

Meaning one user cannot see the global fields of another user.

Michael

[Genx]

FYI: http://faq.filemakermagazine.com/index.php/Global_fields#Session_Behaviour_in_different_environments