A READER ASKS
I need to ensure that a compound key is unique within a table and can't seem to figure out a sensible way to do this. If I use a calculation field to concatenate (build) by compound key I can't specify a unique validation. Access does this type of thing automatically. Any thoughts or guidance on this
Well, the easiest solution is add a field to the compound key that is always unique.
field A & field B & Field C (field with unique sequential value)
More info about the author and FileMaker in general, contact me at email@example.com.
© 2008 - Dwayne Wright - dwaynewright.com
The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.