Discussions

 View Only
  • 1.  duplicate results in a Formula - Multi-select Text field

    Posted 09-13-2022 16:26
    I am getting duplicate results in a Formula - Multi-select Text field.  It looks like this:


    My formula and settings look like this: 


    Can anyone tell me how to eliminate the duplicate Air District results within each record? For example, for Customer #106, I only need it to show "South Coast" once, not three times.  I know it's doing this because that Customer has 3 records in the Facilities table and they are all in South Coast. 

    I am really new at this so I couldn't make sense of the answer in a similar post.
    Thanks!​

    ------------------------------
    Jennifer Colomb
    ------------------------------


  • 2.  RE: duplicate results in a Formula - Multi-select Text field

    Posted 09-15-2022 16:48
    Can you roll these up to the parent table with a Summary(Combined Text) in the relationship then bring that new field back down if you need it in the Child Record?

    ------------------------------
    Tammie King
    ------------------------------



  • 3.  RE: duplicate results in a Formula - Multi-select Text field

    Posted 09-16-2022 11:01
    These tables aren't related, though. I'm using a formula query instead of relating them.

    ------------------------------
    Jennifer Colomb
    ------------------------------