Hello guys,
I am trying to help my girlfriend finish a report for school and I have encountered a problem. We are both new to using MS access.
We have created 2x Tables that store information 2x Forms that allow for new entries/edits and a report that calls information.
The issue we have encountered is when creating the report, she created it from the "Products" table, so any information included in the products table i can easily call by adding a field and typing in the fields names.
However there is some information in the Suppliers table/form I need to call into my report, but since the report was generated from "Products" I do not know how to do that.
So two questions.
1) Can I call information into the Report from another source other than the one the report was created from and HOW
2) To make this simpler next time can I create a report from multiple tables/forms instead of one?