We have a database that track HW database. We need to modify it so our staff can input as much as 5 different pieces of hardware that will get recycled. The fields (CSD Label, Status, Description and Resson for Disposal) are to be grouped for a particular item. With the current layout, as soon as we change the first CSD label, the others will change as well. How can we design so each group will reflect different HW item?
Note: when staff type in the CSD Label field, it will look up value in the HW table and populate the Status and Description fields.