I am having trouble conceptualizing how to set up bulk items in our application. We have assets out in the field with serial numbers, but within those assets we need to track our bulk items (which are filters) that we need to service and change every year. We do not have serial numbers for these, we track them by date and type.
How would I set up a table to table relationship with the filters being a part of the asset with the serial number?
I should also mention these filters may also be "stand alone" and not necessarily attached to one asset!