I am attempting to find a way to link one record multiple times. I’m trying to cost jobs and need to add the necessary material which I have in a separate table in the same base. I can link multiple records and have them add up however I cannot link one record more than once which is necessary because every record is in a quantity of 1. So for example one job may require 5 feet of wire where another would require 10. I cant change the original record to reflect these numbers because I would have to make a new record so they don’t conflict and by doing so would make the products page too large to be able to update as prices change. I attached an image of the basic setup in the table. I don’t think there are any current features to accomplish this.