Topic: change the dB structure

Hi  Dmitriy,

I want to change the dB structure, I’ll explain. First remove in [ frmTest the items combo boxes cbProdType - Comp. Product Group (*) and  cbTypeComp - Type compressor (*) ]. Now a want to use table – compproducts with Field Names  iprod = product number , idesc = compressor type. Then create a new SQLite. DB file if necessary? The goal is when scan the product number auto display the correct compressor type in a txt box or label. See frmProdModel. The structure of the reports (SQL) must also change, but if you give an example then I can arrange the rest. I send the project - ACTestDev-2015  to shared drop box folder. Thanks in advance, Carlo