Re: [SQL] How would I store little key-Nr to text lists?

2010/7/10 Andreas : >  Hi > > how would I store little key-Nr  to  text  lists? > Like e.g. > > colors > 1  red > 2  green > 3  blue > > Maybe I later also need to add  4 yellow? > > Obviously the numbers are used for foreign keys in data tables and the texts > appear in selects. > On the other han

[SQL] How would I store little key-Nr to text lists?

Hi how would I store little key-Nr to text lists? Like e.g. colors 1 red 2 green 3 blue Maybe I later also need to add 4 yellow? Obviously the numbers are used for foreign keys in data tables and the texts appear in selects. On the other hand users should chose from listboxes in an ap