Search results

Thank you so much for the clarification. I think I've got my relationships and Tbls setup correctly now. I'm going to rework my forms as you mentioned in the "I would:" section. Thank you again for all the help today! I'm confident I'll be reaching out again tomorrow.

Thanks for the tip LarryE. I've noticed this as well as I've begun constructing reports and forms. I created a copy of the DB and began cleaning it up where possible.

Thank you! That actually makes 100% sense about not having OrderNo be a primary key in InboundReceiptsTbl. I've made it foreign, and have created the append query. I'm still stuck on how to make this function when the user clicks the checkbox. The help thus far is much appreciated!

Hi and thanks for the welcome and response. I want the end user to be able to click the checkbox next to the material they are receiving. The materials list is populated via a Purchase Order entry form. So when the user goes to receive these materials, they can simply type in the PO# and the...

Thank you for the reply. I've added snapshots of the tables in reference as well as the form and subform structure. And yes, I want to click the checkbox next to the material in the subform and have it create a new record in the "InboundReceiptsTbl".

Hello, I'm building a tool for my company to use to track inbound receipts against purchase orders and materials. I have it in such as way where the form for receiving shows a subform, and when a PO# is entered, the subform will display all materails related to that purchase order. I want to...