Single Database, Multiple departments
Hello, Im looking to create a database that will have multiple departments, and the base asset management file is great, except I'd prefer to have different category lists based on the value for departments, and for users to only be able to change items or create items with the value of their department. Am i sounding crazy here?
So the workflow is
Login as a (Department) User >> permisisons: user can only view or add items in their dept
View/Checkout/Add items (again, only in dept)
Category list (dependent on dept selection)
Any assistance would be appreciated.