gloerick

Great thank you, It was in the number formating options "set to leave data formated as entered" fixed right up THank you much for the fast response and resolution, most appriciated. Thx Erick

Hello All, In creating a new layer I have a number field for account numbers, However when the number exceeds 7 characters and if you click out of the field it will open spaces in the field no longer showing all numbers until you reclick in the field and all numbers look normal. This would not be such a big deal but I need to print these numbers and not spaces in the field. Why would clicking out of the field make it show spaces in the number and not the entire number until reclicked into ? Any help please. Thx much Erick

MAN THANKS, This was absolutly perfect, gives the text for the dollar amount. now I can print customers checks right from filemaker, thx so much. Erick

Hello All, Can someone please help me on a layout, I am making a layout to look like a personel check. Please how to take the number of the total say 10.95 and turn it into text such as ten & 95/100 or $106.30 into say One Hundred six & $30/100 for the text line of the dollar amount on checks. Any help please Thx, Erick

Hi, Yes this does make it show in the filemaker but not online. calling the field with the CDML and it shows as $15.9 same if I call the field with a PHP script seems the FM exprts the value only if it is 1 or more, if it is zero it ignors it ?? thx erick

Hello All, I have the DB online but the total field does not show the "0" zero on the total abount $15.90 shows as $15.9 how do I get the 0 to show ? Thx Erick

Web is how pages are being served, They login with a name and pass, this name and pass is simply a find request on the users DB, it finds thier record then passes the info to the results page which in turn sets all the cookies for that user. It works fine but you have to login to the DB to add new accounts because some of the cookies info are required and can not be changed by the person loging in. If I can get it to find all this info in the users DB from one or just a couple of cookies when a new account is sent in to the new account DB from them I could allow a much more free system to them to send in new accounts and not lose control over some of the fields. Thx Erick

Hello All, I'm looking for a way to search one DB from a value entered in another.. I have a newaccounts DB that recieves new account info and I would like to populate it by looking up info in another DB based on one of the fields from an entry in the newaccounts DB.. Currently all HIDDEN fields in the DB are passed to it from cookies I set when a user logs in that are setup in a user DB, values I want set a certien way so it is proper when a new account comes in.. As of now I am setting a bunch of cookies to pass this set info around while they are in the DB pages.. I am looking to set maybe one value like name=whatever so when they send in a new account to the newaccounts DB that DB will lookup a record in the user DB with a matching name and then import all values to the new record in the newaccounts db just submited.. This way I can set only a few info cookies from the users DB and when a new account comes in to the newaccount DB it will lookup all the other values I am currently setting cookies for and improt them to the new accounts record. Any help would be most appriciated... Erick