Nov 7, 2020
0
Level 4
Make Table Relationship
I have a table issue and store data like this.
Id Unit_id slave_id Team_id AcknowlegdeStatus
1 2 3 5 0
2 2 4 5 0
3 2 5 5 0
4 3 null 6 0
5 7 null 6 0
So i want to create a table My stock after guys acknowledged the in mystock table i will have this data
Unit_id,slave_id and team_id,
How can i make the relationship with issue,mystock,sales table
Note: Unit_id, and slaveid can be combine because one unit_id can have two or three tables
Please or to participate in this conversation.