how to make 14 digit (xxx) xxx-xxxx phone # fields when entering phone #'s in a field
I need to know how to create the formula, value, or calculation for the 14 digit (xxx) xxx-xxxx phone # fields in my contacts table of my database. I want to be able to just type in the 10 digits of the phone numbers (including area code) by entering only the 10 digits. I just created a database and inputted all the contact phone numbers as straight numbers (xxxxxxxxxx) until I can get a response that will allow the data to display properly. Thanks for the help.
Also I would need to know in what particular area of FileMaker Pro 11 to place this information into and very specifically how to write out the formula or calculation or ??? (from A-Z). In effect I need a walk through. I'm a newbie to File Maker. I would appreciate any help.