i make a "macro" of "bunch of things no relevants for the domain"

see:
in the same table

id = 0001
descrip ="Country" and
ctableId = 0000
id = 0002
descrip ="Charge" and
ctableId = 0000

id = 0001
descrip = Peru
ctableId = 0001 && link to Country
id = 0002
descrip = Chile
ctableId = 0001 && link to Country

id = 0001
descrip = Engineer
ctableId = 0002 && link to Charge
id = 0002
descrip = Doctor
ctableId = 0002 && link to Charge

i have in 1 table all the data no relevant but necesary only for information, only make "select id,descrip from bunch where ctableId=[0001] into cursor curcountries" and i obtain all the countries for a combobox for example and in another combobox i put "select id,descrip from bunch where ctableId=[0002] into cursor curcharges" and i obtain all the charges and this again and again for all the data no relevant, but in n tier schema how make this work?

Best Regards

Francisco Morosini




>>Hi, in the pre-MM time i have a combobox class with a link to a table with this struc:
>>
>>id c 4
>>descrip c 20
>>ctableid c 4
>>
>>when i have :
>>
>>id = 0001
>>descrip ="Country" and
>>ctableId = 0000
>>
>>
>>id = 0001
>>descrip = Peru
>>ctableId = 0001 && link to Country
>>id = 0002
>>descrip = Chile
>>ctableId = 0001 && link to Country
>>
>>i send a key like "0001" and the SQL process in the init Combobox class make a query, and there put all stuff only relevant in information but not in domain analisis
>>
>Are all the countries in one table, or do you have other country tables. What is the cTabled for?
>>now , in the MM time, whats the best approach to apply this method?, the same or another?
>>
>>Best Regards
>>
>>Francisco Morosini