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