How to show the product information and the orders in the same report

[cafirf]

Hi Team,



The question I have should be easy to answer but I am new to Access. I have a table that that contains the details of each product that I have in my inventory. I created a report to show all the products and its description, I would like to add to this report list of these products in my inventory. The Idea is to have in the description of each product in my report (records from the tbl_product) and list these products and its position in the warehouse (tbl_Inventory). I also already created the relationship between both reports, where tbl_inventory is the child tbl_Product is the parent table.

Thank you in advance,
Cafi.

[orange]

Spend some time with the links in post #3 here.

[cafirf]

Spend some time with the links in post #3 here.

Thank you! I will go through the material.

regards,
Cafi