2 Replies Latest reply on Jun 1, 2015 6:41 AM by RogierdenDekker

    field contains part of text



      field contains part of text


      Hi, I'm looking for a way to relate tables based on two fields with selection checkboxes, when any one or more of the checked boxes match. The checkbox list is dynamic, from a third table. Both the related tables will have other boxes checked that don't match. I've tried a pattern count, but that doesn't work when non-matching boxes are checked.

        • 1. Re: field contains part of text

          The problem you may be having is when you select multiple checkboxes, you get a return separated list.  Put a second checkbox field on the layout, but make it a text field, and make in about an inch wide and 4 inches tall.  Watch what happens to that field as you check and uncheck boxes.  The order of the list changes.  If you're trying to match this on both sides of a relationship, and the boxes aren't checked in the same order on both sides of the relationship, I would think this would fail.

          Can you post a sample file or some screen shots of what you are trying to accomplish.  Also it's very helpful if you use exact words to describe what you are doing instead of first table, second table, field one, etc.

          Also your title says field contains part of text, but nothing is mentioned about that in the post

          You may want to also research 'multi key' to see if that is something that is more in line in what you are looking for.

          • 2. Re: field contains part of text

            The multi key search solved my problem in a much easier way, thanks a lot.

            Sorry for the unclear post earlier.