validation script or calculation???
Hello - I have an issue where I need to have my parent database compare fields to see if the building and room listed for an employee matches the building and room data in a related facility db. If they don't match then it needs to create a flag (an x or something like that in a field) so that the user can double check the data.
What is the best way to go about this? What I tried failed so I am stumped.
I am new to calc fields - using FileMaker 10 that is hosted on FileMaker server. Also, I use a Mac.
Any help is appreciated as I am not sure how to proceed.