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

  I found "cook" two days ago. Played around with it for a day and then within a day got rid of two legacy applications in IBM Lotus Domino Notes and replaced them with "cook". It was really easy. A piece of cake. Actually it was even easier than cooking. Cooking involves more work than developing with "cook". What can I say about "cook"? Great application great price for what it delivers great forum with a lot of information and fast responses active and friendly community fast forward moving development cycle So what should I say "Monsieur Le Cook"? Keep the good work going it will lead to success. Having become a paying member in the words of Edith Piaf may I say ..... non rien de rien ... je ne regrette rien. Vive La France.
FK (JED)
         

Get Started