AnsweredAssumed Answered

Relate field with multiple tables

Question asked by wilsonpark on Dec 14, 2015
Latest reply on Dec 17, 2015 by coherentkris

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

Outcomes