need to require validation of 5 specific feilds prior to creating a unique id#

[Reese196]

:D : I'm sure this has been asked many times before but I can't seem to find it. I would greatly appreciate any help you can offer, even if it's a link to another posting. Here's my delima: I am creating a database for a moving company, what I would like to do is require that we enter specific information (name, phone, email, address) before creating a file number for this client. This will allow for us to have a more sequential file number and ensure proper data entry by the receptionist. Okay so I think I need to create container fields and then a script which would then create a new record. My problem is I don't know how to do any of this. Please, any help you can offer will be greatly appreciated, I have learned alot from the manuals I have but I just cannot grasp this concept.

[mr_vodka]

You can enter the data into global fields and then your script can create the new record with the global values.

[Reese196]

John, Thanks a million for your help, I'm such a newb, but fascinated with everything Filemaker has to offer. I have setup the global fields and the script, now my final question is once the script populates the fields of the new record how do I delete the data from the global fields so the next time I create a record I enter new data?

[bcooney]

This will allow for us to have a more sequential file number...

My advice is to avoid assigning any meaning to key fields. If you want a file number that is sequential, then don't use it as your key field in the table.

To answer your question to John, since he's offline, just use Set Field to set the globals to "" (that's an empty quote which means 'nothing'), at the beginning of the script.