Hello everyone! I'm building an Inventory System where every Department has their own products list.
I have the Department table with:
PK ID - Name
I have the Inventory table with:
PK ID - Product - Category - Observations - FK DepartmentID
I want to be able to see the products separatly for every department in the system. I mean, if i select the inventory for Department 1, see the product list assigned to Department 1.
In those controllers i just have the CRUD operations. There's no problem with that. What can i do? Thank you everyone in advance.