Is it possible to create several enumeration fields within one table that end users can populate without having to make a completely separate table for each field? i.e.,
A company in "Branch A" only accepts certain equipment....in this case...it's computers......so they will build their lists using fields like
Service Type: Express, Standard, Overnight
System Make = Toshiba, Compaq, Dell, etc...
System Type = Laptop, desktop, netbook, etc...
Color = Black, White, etc...
Let's say another branch, B, doesn't work on computers...but they fix phones and they want their own list of equipment fields to use phone stuff and not reflect the computer list.
I would like to have have one back end page layout where each branch can have their own lists and alter them according to their own needs. I just can't seem to create a dynamic enumeration list that an end user can edit(add or remove listed items) without making a separate table and then linking it with a FK.
Any help will be greatly appreciated.