Hi All.
I created part of my Inventory database that give ability add devices to the system. Now I added new tblRequest table that will be source for fRequest form. That form will using to save a new device requests. In the relationship I linked tblDevices table to tblRequests table. But I cannot figure out how create source of data for cboDevice combo box in new fRequest form. I would like before select according device first of all to filter data by Brand then by DeviceType and finally select device with according device type, brand and model and then save a correct DeviceID value to tblRequest table. I will appreciate if someone will show how it to do. The attachment contains database file.
Thanks.
AddNewCascadeCB.zip