Jump to content
Sign in to follow this  
Mark Appleby

Finding duplicate references

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???

Share this post


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.

Share this post


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...

Share this post


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!

Share this post


Link to post
Share on other sites

FWIW,

I am pretty sure the picture is Emma Gene Coco (sp?).

She was a comediene from the 40-50 who appeared on Sid Cesars Show of Shows.

Share this post


Link to post
Share on other sites

Emma Gene?!?!:??

What do they teach kids these days? I mean, really!

Imogene Coca was on Sid Caesar's "Your Show of Shows" for (I believe) two years, along with many plays. She died last year at the age of 92.

Share this post


Link to post
Share on other sites

You've got to feel sorry the poor sucker who owns that "mug".

Did you pay any royalties ?

Share this post


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.

Share this post


Link to post
Share on other sites

OK, here's a good question... how does one clear an image without posting another?

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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