Here's a little background -
Tables - Cust_Order_Line, RMAFrmTbl, RMADETAILSUB_2
It's an RMA tracking database. The Cust. Service department creates the RMA. Then QA tests the returned product. 1 RMA may have more than 1 line item. QA needs to enter their results from testing for each product listed on the RMA paperwork.
So here is what I am wondering - I have a form that QA enters the RMA_ID and a query runs to pull up the data for that RMA. It lists all the different line items on the RMA. I would like to have some of the data from that query be put into a subform. From there the QA person would enter their test results and then save the record. How do I have the results of the query entered into a subform? I need the subform to be in datasheet view.
Thanks for any suggestions.
Tables - Cust_Order_Line, RMAFrmTbl, RMADETAILSUB_2
It's an RMA tracking database. The Cust. Service department creates the RMA. Then QA tests the returned product. 1 RMA may have more than 1 line item. QA needs to enter their results from testing for each product listed on the RMA paperwork.
So here is what I am wondering - I have a form that QA enters the RMA_ID and a query runs to pull up the data for that RMA. It lists all the different line items on the RMA. I would like to have some of the data from that query be put into a subform. From there the QA person would enter their test results and then save the record. How do I have the results of the query entered into a subform? I need the subform to be in datasheet view.
Thanks for any suggestions.
