Help with calling information to a field

[Courtney2287]

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?

[Courtney2287]

I have figured out that to create a report that can call information from multiple queries I have to first create a relationship. The confusion comes from the creation of relationships, exactly why and what do I have to do.

The report needs to call information that is unique to each table.

For instance the information in Products i need is ( Vendor ID // Product Description ) and from Suppliers i need ( Vendor Name )
I don't understand what relationship has to do with this as when I try to create a relationship it wants me to match the unique items to an item in the other table.

For instance Vendor Id in Products to Vendor Id in Suppliers ??

I just need to be able to call 3 pieces of infrmation
Id - > from Products
Product Description -> from Products
Vendor Name -> from Suppliers

Any help?

[Courtney2287]

Well.... thanks for all that great help

[ItsMe]

I suggest you research the term "Normalization".

Post three in this thread has some link to some tutorials.
https://www.accessforums.net/access/...tes-25569.html

You need to define Primary Keys in your tables. These unique identifiers can be placed in other tables as Foreign Keys. You can join tables by using PK and FK relationships.