Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2013
    Posts
    3

    Arrow Help with calling information to a field

    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?

  2. #2
    Join Date
    Oct 2013
    Posts
    3
    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?

  3. #3
    Join Date
    Oct 2013
    Posts
    3
    Well.... thanks for all that great help

  4. #4
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows XP Access 2003
    Join Date
    Aug 2013
    Posts
    7,862
    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.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Calling tables within a calculated field
    By TonyB in forum Reports
    Replies: 4
    Last Post: 09-06-2013, 03:54 AM
  2. Replies: 3
    Last Post: 07-16-2013, 03:22 PM
  3. Replies: 8
    Last Post: 05-13-2013, 06:26 PM
  4. Merging information to create ID field.
    By Raga32 in forum Forms
    Replies: 3
    Last Post: 08-08-2011, 03:09 PM
  5. Replies: 1
    Last Post: 06-02-2011, 04:11 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums