Dear experts,
I'm breaking my head over the correct setup of my tables in order to be able to enter value in a combobox based on the selection in another combox in the form :banghead:
The database I'm trying to build will keep track of all office related purchase records (desks, computers, copiers, etc.) and the office assests.
Have attached picture of my tables draft.
I'm struggling wiht the equipment, brand and type part.
Once in the form I would like to be able to select Equipment from combobox and then when selecting the Brand comobox get a filter based on Equipment and when selecting the type combobox the types.
E.G. cboEquipment: Printer gives in cboBrand the printer brands: HP, Epson, Brother, Ricoh. When selecting in cboBrand for example HP, then in cboType it lists the printer types from HP.
Can someone help me in the right direction.
Tanks.
I'm breaking my head over the correct setup of my tables in order to be able to enter value in a combobox based on the selection in another combox in the form :banghead:
The database I'm trying to build will keep track of all office related purchase records (desks, computers, copiers, etc.) and the office assests.
Have attached picture of my tables draft.
I'm struggling wiht the equipment, brand and type part.
Once in the form I would like to be able to select Equipment from combobox and then when selecting the Brand comobox get a filter based on Equipment and when selecting the type combobox the types.
E.G. cboEquipment: Printer gives in cboBrand the printer brands: HP, Epson, Brother, Ricoh. When selecting in cboBrand for example HP, then in cboType it lists the printer types from HP.
Can someone help me in the right direction.
Tanks.
Attachments
-
tables.PNG
