2 Replies Latest reply: May 10, 2016 5:44 PM by Stefan Wühl RSS

    Avoid synthetic keys

    Isaac Paz

      Hi.

       

      I have a problem with the following scheme:


      Table A

      ERPOthers
      X
      Y

      Table B

      ITEMOthers
      A
      B

      Table C

      ERPITEMOthers
      XA
      XB

      Table D

      ERPITEMOthers
      YB
      XA

       

      By making the load several synthetic keys are produced , because there are two tables with  two fields with the same name, which are related to Tables A and B.

      C and D are  differents tables between them.


      What can i do  to fix  the problem and  keep the idea of the scheme ?

      a greeting