Results 1 to 2 of 2
  1. 07-05-2011, 02:38 AM #1
    mer
    mer is offline Novice
    Windows Vista Access 2007
    Join Date
    Jul 2011
    Posts
    6

    relationship between the tables

    Hi all!!
    I'm newbie to microsoft access 2007.
    I'm doing a system which required me to get the quantity of current component in hand from the data.
    I'm quite confused of how to relate my tables to know the current component.


    Hope some help from you all. I'll appreciate it and THANKS very much!




    *File attached
    Reply With Quote Reply With Quote
  2. 07-05-2011, 05:52 AM #2
    mer
    mer is offline Novice
    Windows Vista Access 2007
    Join Date
    Jul 2011
    Posts
    6
    my desired output will be showing (a)which ComponentNumber i have now and (b)the quantity of those components respectively and (c)the person who bought it.

    Thanks in advance. I'm really confused and hope someone can correct me if i make any big mistake
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Relationship 1:1
    By MrLestat in forum Database Design
    Replies: 1
    Last Post: 05-18-2011, 07:13 AM
  2. One to one relationship
    By anemoskkk in forum Access
    Replies: 1
    Last Post: 04-13-2011, 12:05 PM
  3. Relationship - Three Tables - No Duplicates
    By Huddle in forum Database Design
    Replies: 15
    Last Post: 07-27-2010, 07:45 AM
  4. Relationship
    By pcandns in forum Access
    Replies: 2
    Last Post: 04-01-2009, 09:32 AM
  5. How to make Relationship between tow Tables?
    By nader in forum Access
    Replies: 1
    Last Post: 10-28-2008, 08:38 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums