Welcome, Guest
Username: Password: Remember me

TOPIC: Dynamic Enumeration Fields in single table

Dynamic Enumeration Fields in single table 24 Jan 2014 20:08 #12097

  • larctech
  • larctech's Avatar
  • Offline
  • New Member
  • Do what you can to make the world a better place..
  • Posts: 8
  • Karma: 0
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.
The administrator has disabled public write access.
Time to create page: 0.083 seconds

Get Started