Jump to content

This topic is 6699 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I am having a problem creating a mailing list. Can anyone tell me how to ensure that when entering a record that it is unique. I have set up a text field to be calculated. This is "Title & Sirname & address1 & Address2 etc" I have also set the options that this field should be unique. My problem is when I enter two records with the same details nothing happens???

Link to post
Share on other sites

Calc fields cannot be directly checked for uniqueness. However...

Create a self-relationship, based on the calc field. Next, create a calc field (call it "one") that returns the number 1. Finally, create a calc field that returns a warning if the sum of the related "one" field is greater than 1.

BTW (I have now put on my pedant hat), I presume "Sirname" (sic) is a typo.

Link to post
Share on other sites

There is a Filemaker TechInfo Article on validating calculation fields. Search for "validating calculation fields". I've used it and it works! Not for the feint of heart though...

Link to post
Share on other sites

Do you like it? I'd like to say that it's me in my party dress, but alas I found it on the web somewhere.

I laugh too, glad you enjoyed it!

Link to post
Share on other sites

No, I haven't paid royalties... I cannot find the coyright holder to send them a cheque! As much as I like it I'm gonna take it off, it's not appropriate to use copyrighted material without permission.

Link to post
Share on other sites

This topic is 6699 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.