Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC:

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

  • larctech
  • larctech's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Do what you can to make the world a better place..
  • Posts: 8
  • Thank you received: 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.

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
Time to create page: 0.104 seconds

Les générateurs de code je les connais presque tous pour les avoir essorés en long en large et en travers ... mais celui ci c'est vraiment un outil formidable de simplicité et d'efficacité !
Marc. (liubov - Forum)

Get Started