Hi All.
I want to create a small database for my equipment inventory but I have some problems on picking a structure.
I create some tables:
I briefly describe my script. The f_Device form gives user ability to add new device to the system. That form has cascade combo boxes cboBrand, cboDeviceType and cboModel. When user selected all required value data will saved. In case when user need add device but brand of new device doesn't exist in the system a user will click button from the right from cboBrand to call form fBrand to add new brand name. In case when user need add device but device type doesn't exist in the system a user will click button from the right from cboDeviceType to call form fDeviceType to add new device type. The similar story for device model.
Device Brand DeviceType Model DeviceID
BrandID
BrandDeviceID
ModelID
DescriptionBrandID
Brand
DeviceTypeID
DeviceType
ModelID
BrandID
DeviceTypeID
Model
The Form1 is test form. It has only one button to call f_Device form to add new device.
The f_Defice form binding to Device table
The fBrand form binding to Brand table
The fDeviceType form binding to DeviceType table
I'm feeling that DeviceType table has problem but cannot figure out how to fix. What structure of that table must be. And second question is how to avoid duplicates in case when need to add new device.
I will very appreciate if someone can help me to solve those problems.
In the attachment my last version of Access file
Thanks.
InventoryDBF.zip