August 15, 200124 yr ok, say i have 2 fields, NAME and DATE. Let's say record 1 has name: ABC and date: 1/1/1. Now, I want to create a script such that it will check that when a person make record 2, 3, 4.... it check with any other record to make sure that ABC and 1/1/1 are not reused. If it is reused, it will not allow the user to create the record and make user abort or re-enter the data... Thanks in advance for any advice.
August 15, 200124 yr Check out the FAQ I wrote at this link: http://www.fmforums.com/ubb/cgi-bin/ultimatebb.cgi?ubb=get_topic&f=8&t=000017 It can be adapted to solve your problem. Simply create a calculation of the name and date and use the technique in the FAQ to validate that it is unique. Chuck
Create an account or sign in to comment