3 Replies Latest reply on Dec 17, 2015 7:56 AM by coherentkris

    Relate field with multiple tables

    wilsonpark

      Dear friends,

       

      It's possible to make a field as a foreign key for multiple tables?

      i need it in my STORAGE table, witch recieves from may different tables


      In my case, my production line has many outsourcing steps

       

      i.e.: Product comes form outsourcer 1 can go to STORAGE or go to outsourcer 2

            Product comes form outsourcer 2 can go to STORAGE or go to outsourcer 3

            ....

            Product comes form outsourcer x can go to STORAGE or go to outsourcer (x+1)

       

      - Every step, the product comes to me before it goes to the next outsourcer.

      - Every outsourcer has its own TABLE, and I'd like to use the Primary Key of their record (OUTSOURCER 1::__pkOutsource ; OUTSOURCER 2::__pkOutsource ; OUTSOURCER x::__pkOutsource) as a Foreign Key of my STORAGE table

       

      Best regards

       

      Wilson Park