AnsweredAssumed Answered

Relationship: Invalid?

Question asked by dansan500 on Nov 5, 2012
Latest reply on Nov 5, 2012 by philmodjunk

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.

Outcomes