Results 1 to 2 of 2
  1. #1
    Kevo is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2011
    Location
    Kodiak, Alaska
    Posts
    86

    I am stuck already! Table Issue.

    Hi,



    I know I have a lot to learn before I am close to ready to actually do my project, but I started creating a few tables just as practice and because I learn by doing.

    Here is the issue....

    Created tables below:

    Instrument Category (this tells the different categories of instruments)
    Category

    Departments
    Department


    Instruments
    Instrument Name
    Qty
    Category
    Department

    Now I want an "assembly table" to create an assembly of instruments into a set......Here is the problem- How do you create a table that will allow you to enter say - (6) Instrument A, (8) Instrument B, (2) Instrument C, etc...?

    Set
    Instrument Name
    Qty

    If you can help me understand how to do this it will push me way down the road!

    Thank You in advance for your time,
    Kevin

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    The first few topics here will get you on the right track.
    http://www.rogersaccesslibrary.com/forum/topic238.html

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

Similar Threads

  1. Table Results Issue and Ordering
    By AcmeGearSteve in forum Access
    Replies: 1
    Last Post: 10-20-2010, 12:01 PM
  2. Table link issue
    By rbienko in forum Access
    Replies: 2
    Last Post: 09-30-2010, 11:18 AM
  3. Replies: 7
    Last Post: 11-22-2009, 02:38 PM
  4. Make Table Query Issue
    By tmcrouse in forum Access
    Replies: 0
    Last Post: 07-23-2009, 03:20 PM
  5. Table/Form Issue
    By ginap in forum Access
    Replies: 3
    Last Post: 06-17-2009, 01:12 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