Results 1 to 2 of 2
  1. #1
    luck_touch is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    1

    How to set codes linked to my products in Access 2010

    Dear!


    I am LUCK. I am using Access 2010. I have 4 columns in my file. They are "Code", "Item", "Qty", and "Amount" . I have 5 products with my own codes. It means the codes are set by me. For example, 00001 for ruler, 00101 for book, 00201 for pencil, 00301 for rubber, 00401 for pen. My wish is to link the code and product together. It means that when I sell a pen, I must type the code for pen (in the "code column") and I must type pen in "Item Column", so I think it really takes long to do this because I will really make a mistake because the code and item are not linked at all. What I mean is that when I fill or know the code, I will get the product automatically in the "Item Column" or vice versa.


    Here's what I need you to help to solve.


    Now I have set the code 00401 for pen.


    So when I need to fill the information. I wish to fill the code in the "Code Column" and then the word pen is automatically shown in the "Item Column". In this case, I will be able to get right code linked to its product.


    Anyone experienced this. Please feel free and kind to explain to me in details because I think it's the best way to help me to avoid mistakes by chance. Or please give me another method that is similar to what I need.


    Thanks a lot and I am looking forward to hearing from you as soon as possible.




    Best wishes to you and may God be with you all the time!


    My best regards,




    LUCK

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    You need a table of Products and table of Sales. Review this tutorial about Relational Database Principles: http://forums.aspfree.com/microsoft-...es-208217.html
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 3
    Last Post: 01-30-2012, 09:57 AM
  2. Replies: 3
    Last Post: 01-03-2012, 12:28 PM
  3. Replies: 1
    Last Post: 08-11-2011, 01:52 PM
  4. access 2010 windows7 nas linked tables
    By mikeb in forum Access
    Replies: 7
    Last Post: 03-18-2011, 03:59 PM
  5. Linked table manager in Access 2010
    By Delta223 in forum Access
    Replies: 3
    Last Post: 01-07-2011, 12:37 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