Final data taken out is in CSV format with all fields are coded like "1",2", "3" etc. There are more than 100 comboboxes with structured dropdown items. Comboboxes can be linked to tables or value list. Tables will be more helpful since queries can be built to describe the codes but value lists not. The downside I foresee is, it may be required to create 100+ tables which I think is not ideal.
Is there any standard approach to handle the dropdown values for numerous comboboxes? I need only codes for CSV but with description for all other purposes.
Please help.
Is there any standard approach to handle the dropdown values for numerous comboboxes? I need only codes for CSV but with description for all other purposes.
Please help.