Determine how to generate Combox box values - RESOLVED-

[Shaitan00]

I have 3 combo boxes that need to be populated with information.
CBCategory (key, value)
CBType (decimal, long)
CBLocation (home, work, road)

These are independent fields for which I need to store the available options (cannot be hard coded incase changes to the fields are require like adding or removing certain choices).

My first idea was to use SQL (already using it for my application so..), so I created a Table called “Fields” and added 3 columns (Category, Type, and Location). However SQL works by Row and the way I formulated this with 3 independent fields per row looks really bizarre.

Either I need another option (any ideas? Registry would be nasty) or I need to formulate the SQL Table properly (can it be used for something like this?) or I can also create 3 separate SQL Tables (not recommended seeing as these fields will only contain 2-10 options each, generating 3 tables for that few entries is pointless and a waste of space (agree?)

Any clues or help would be appreciated.



- RESOLVED -
Using 1 Table and isolating the required columns (SQL) works like a charm.