I'm trying to reference a specific record on a layout that I can assign a quantity to. For example, I have a layout for scheduling an event and I want to be able to input the number of chairs they will use in their setup. Chairs are listed as part of our inventory as a resource and I'd like to reference that specific Primary Key on the form instead of having to go through and find "chairs" in our inventory for every event and then enter the quantity. I'd like to just have it auto-populate with the pk and the user to just enter the number needed which would in turn add it to line items for an invoice.
I hope this makes sense, I'm still a novice. Any guidance and suggestions are appreciated.