I am having a problem with a subform working properly. I am using 2 tables with this form/subform-- 1 table has RMA information related to returned goods and the other table has detail on items returned, one record per item. The RMA number is the primary key in the RMA table. The Items table has the RMA number indexed with duplicates OK. I created a subform for the Items table using a query to display all the item records per RMA number, but no items will appear on the subform at all. I suspect that the subform query is the problem. How do I link the RMA number for the form and subform? I will also want to print a report using the same concept.
Start Free Trial