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