Article View: comp.sys.mac.apps
Article #9448Unique Calculation Field checking in Filemaker Pro
From: Craig C Schanning
Date: Sat, 12 Dec 1992 21:58
Date: Sat, 12 Dec 1992 21:58
24 lines
1542 bytes
1542 bytes
I am currently using Filemaker Pro 1.0, but plan on upgrading to 2.0 pretty soon, so if you know an answer that only works in 2.0 please tell me anyway. Here is my question: I currently have a filemaker document that contains a bunch of peoples names and other data. I have a First Name field and a Last Name field. I want to have to computer automatically verify that the person is not already in the file. There is no option for this when I make a full- name field that just concatenates the first and last name fields together. I don't really want to make the Full Name field the field where I enter the data, since it is hard to pick out the first and last names out of that field when some names have "Jr." or "Sr." at the end or when some names have middle initials and some do not. Does any one know a work around, or do I have to just do a find before every new record I make? -- *************************************************************** * Craig Schanning - squid@carroll1.cc.edu * * And the next thing you know, ol' Jed's a millionaire * ***************************************************************
Technical Details
Message-ID:
<3541@carroll1.cc.edu>Path:
arc1-ca.pugleaf.net!sparky!uunet!spool.mu.edu!carroll1!squidShow Full Headers
Complete Article Headers
Path: arc1-ca.pugleaf.net!sparky!uunet!spool.mu.edu!carroll1!squid From: squid@carroll1.cc.edu (Craig C Schanning) Newsgroups: comp.sys.mac.apps Subject: Unique Calculation Field checking in Filemaker Pro Message-ID: <3541@carroll1.cc.edu> Date: 12 Dec 92 21:58:48 GMT Reply-To: squid@carroll1.cc.edu (Craig C Schanning) Organization: Carroll College-Waukesha, WI Lines: 24