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

    Relationship: Invalid?

    dansan500

      Title

      Relationship: Invalid?

      Post

           Table A

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

           row&""&shelf&""&bin&""&Other

           we will call this field (Location)

            

           Table B

           I created a field in this table the same way

           row&""&shelf&""&bin&""&other

           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?
          philmodjunk

               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.