I’m not sure this is even possible but this could be a lifesaver for me. I go into the field every day and take an inventory of what new items my contacts have purchased in the last few weeks. I would like to add their name to the specific product row, whether it’s one item or multiple items. I already have a tab with all my contacts and another tab with all the inventory but I need an easy way to add their name to each item they purchase, preferably a form I can fill out during my stop or at the end of my day.
EX: Contact A purchased Item A, B,C and D
Contact B purchased B,D
Fill out a form that pulls each contacts name and allows me to select from the inventory table the specific items they purchased.
Let me know if you have questions.