Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Mask for SSN field
This can only be done through a calculation field. If you have SSfield (where the users are going to enter the SS) You have to create a calculated field cSSfield that contains the following formula: Left(SSfield, 3) & "-" & Middle(SSfield, 4,2) & "-" & Right(SSfield,4) In...- phaeberle
- Post #2
- Forum: FileMaker Inc.: FileMaker Pro
-
Changing Values
Check the "substitute" function- phaeberle
- Post #2
- Forum: FileMaker Inc.: FileMaker Pro
-
Query "something" or "somethingelse"
Create a calculation field and concatenate both, address1 and address2 (address1 & " " & address2). When entering in find mode, change layout and perform the search in the calculated field, not in address1 or address2- phaeberle
- Post #2
- Forum: FileMaker Inc.: FileMaker Pro
