2 Replies Latest reply on Jan 11, 2017 7:40 PM by sstpierre

    Related table algo



      I'm in deep s...

      I'm trying to relate two table together in a matter that I can't figure it out.


      basically what I want to do is : having a portal loaded by a pop-menu of tree option from gender selection (woman, man or both)


      first I have a table of customer (woman and man)

      wich have a calculated field value of 0 for woman and 1 for man (so are my gender determinated)


      and another table with a pop-menu with tree options for choosing the appropriate gender this way:

      first option = 0 (woman)

      secund option = 1 (man)

      and third option = (tryed everuthing from -1 to 2, etc) - Unisex - to get both gender.


      the pop-menu is tied to a field and - in return - with two calc field that are my condition for the related condition for my tables. (Linked with the gender calc field in my child table)


      the two first are quit obvius

      but I'm stuk with the limitaion of Related Operator wich is only AND - cause I tryed with two conditions to get my third option.


      any clue.

      tx a lot.

        • 1. Re: Related table algo

          Format the field with check boxes. This allows the user to select both checkboxes. If they do, both values are entered into the field, separated by a return. Used as a match field in a relationship, it will match to records with a match value of 1 OR 0.


          You can also get the same list of values with a drop down list or pop up menu if you hold down shift or ctrl while clicking in order to select both values.


          The same technique could be used with your negative 1 value if you set up fields with lists of values such as


          List ( 0 ; -1 ) for female and

          List ( 1 ; -1 ) for male


          that way, -1 would link to both records.

          • 2. Re: Related table algo

            Big tx Phil it really helped me out.

            Just linked my parent field - set as a check box - to my child calc field

            and it rocks !!