Hi, I'd like to create a serial number using today's date and a record number (this is client preference, regardless of whether it's the best way to to do it). I need to create this serial number only if the word "fax" appears in a reference field ("fax" would always be the last three characters in that reference field.) The serial number cannot contain any slashes or dashes. So ultimately....if "fax" is in reference field, I need 082708001, then 082708002, etc. in the serial number field; else it should remain blank. Please help...I can't figure out how to do this without getting slashes in the serial number. The serial number field must remain a text field. Thanks so much for any help!

As long as you base the relational ties on this serialnumber are you on the safe side.

Take a look at:

http://www.databasepros.com/FMPro?-DB=resources.fp5&-lay=cgi&-format=list.html&-FIND=+&resource_id=DBPros000121

...you then make the category this way:

Let(

    [

        mo = Right( "0" & Month( Get( CurrentDate ) ); 2 );

        da = Right( "0" & Day( Get( CurrentDate ) ); 2 );

        ye = Right( Year( Get( CurrentDate ) ); 2 )

    ];

    mo & da & ye

)

And then concatenate it with the generated serial number.

--sd