[color=darkblue]I’m creating a college student records database with Filemaker 4.0 that involves several files and eventually will be accessed by web.
1st Q: Is it worth it to upgrade to Filemaker Pro 6 to be use for the web? How is 6 compared to 4?
2nd Q: Should I have several files corresponding to each form/document that a student submits or combine them all into one file? In addition, what is the rule of thumb on the number of fields for one file? In other words, what is the maximum number of fields I should have in one file?
3rd Q: Once I’m ready to put the database onto web. How can I make the database safe and isolate the web user only to his or her record rather than browsing through the whole database.
4th Q: One thought was to write a script to prompt the user to indicate New or Registered user:
the user selects New then the script would duplicate a database template,
the script would rename it to the file name containing student ID and password,
the script would prompt user to set the password for the new file
and when the student completes the online form, the data is collected by the main database file(s).
Is this the right approach? How can I accomplish this?