1 Reply Latest reply on Nov 5, 2012 2:00 PM by philmodjunk

    Relationship: Invalid?



      Relationship: Invalid?


           Table A

           I created a field that collects information from 4 other fields in the same table


           we will call this field (Location)


           Table B

           I created a field in this table the same way


           we will call this field (Location)


           So when I made the relations ship from Table A

           Table B Table A_Part_CC_Location


           The relationship :

           Table A = Part                            Table B = Part

           Table A = CC                              Table B = CC

           Table A = Location                     Table B = Location


           It doesn't work, Can you please help me.

        • 1. Re: Relationship: Invalid?

               It does can work, but probably isn't the best way to set this up. In order for it to work, the corresponding fields all have to be of the matching data types and you can't use such a relationship to create related records via the relationship such as by entering data into a portal.

               Here are two alternatives that should work better:

               Option 1:

               Discard both calculation fields and match all the individual fields in your relationship instead:

               Table A::Part = Table B::Part AND
               Table A::CC = Table B::CC AND
               Table A::Location = Table B::Location

               Keep the calculation field for one of the two tables (the parent table) and match to a simple text field instead of a calculation field in the other (the child table). In the child table, define the Part, CC and Location fields as calculation fields that extract their data from the simple text field.