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.048 seconds

  I want to save the world...... let's cook a solution about it.
VeCrea (Forum)

Get Started