7 Replies Latest reply on Jan 15, 2012 10:54 AM by GiuliaDeNobili

    calculation perform: find a text among a long text field

    GiuliaDeNobili

      Title

      calculation perform: find a text among a long text field

      Post

      Hi,

      sorry this is a stupid question, I am sure! But I do not find the proper function to do this.

      I have a calculation that says: if I write a Name in the Name field in the New Clients table, check the Old Clients table if that name already exists. It does work if the name I put in is exactly the same but what if there is a typo or there is also a middle name or whatever other case???? I need file maker to tell me if that name might already exist in the Old Clients table so I can go there and check to see if it is really the same client.