Results 1 to 2 of 2
  1. #1
    sunshine is offline Novice
    Windows XP Access 2000
    Join Date
    Nov 2011
    Posts
    2

    So confused with reports!

    I have created 3 tables in my data base, one supplier table holding supplier names and contact details, a parts table holding part numbers, descriptions, prices and lead times etc and a jobs table holding information about the different jobs, their descriptions, serial numbers etc. I want to create a report which displays the part number and what supplier supplies it. How would i do this? I cant seem to get the relationships right!

    Any Help would be appreciated!

  2. #2
    hertfordkc is offline 18 year novice
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    481

    You didn't mention a table relating parts and suppliers.

    Also, is there some relationship between the jobs table and the other two tables?

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

Similar Threads

  1. Just Confused
    By BigCat in forum Access
    Replies: 1
    Last Post: 05-09-2011, 12:57 PM
  2. New at access and confused
    By darlaj5 in forum Access
    Replies: 4
    Last Post: 05-05-2011, 09:46 PM
  3. Newb getting confused.
    By Iggy in forum Access
    Replies: 10
    Last Post: 03-15-2011, 08:50 PM
  4. Confused about relationships and tables
    By MGJP in forum Database Design
    Replies: 4
    Last Post: 01-19-2011, 09:20 AM
  5. confused with append method
    By TP takamiya in forum Programming
    Replies: 3
    Last Post: 09-22-2010, 07:02 PM

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