Results 1 to 2 of 2
  1. #1
    g8rnc is offline Novice
    Windows XP Access 2003
    Join Date
    Jun 2010
    Posts
    2

    Help a newbie

    I created a database with 3 tables:



    Table 1 is a simple table called Categories. It has an autoID field and a category field.

    Table 2 is for Products. It has columns for Part # (Primary Key), Product Name, Category, On Hand Stock, Retail Price, ReOrder Level, and a discontinued yes or no box.

    Table 3 is for Inventory Changes. It has Part Number, Date, Ordered, Received, and Sold.

    What I'm trying to do is create a form that has combo boxes for Category and Part Number. The user selects which category from the 1st combo box and the 2nd combo box (part number) limits it's choices to that category. Then when the user selects a part number from the 2nd combo box the Product Name is displayed in a text field that the user cannot change (display purposes only). Below that I want a simple number input for Ordered, Received, and then Date. All this information should be put into the Inventory Changes table, but the combo boxes and the text display should be pulled from the Products table. This is the part I'm having trouble with.

    I already have the conditional combo boxes working, but when I try to input inventory I get the following message: "The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship."

    Please help! Thank you.

  2. #2
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    courtesy of our very own pbaldy.
    http://baldyweb.com/CascadingCombo.htm

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

Similar Threads

  1. Question from a newbie
    By scarps626 in forum Access
    Replies: 2
    Last Post: 10-02-2009, 03:40 AM
  2. Newbie Here & Stuck
    By FOZILD in forum Access
    Replies: 5
    Last Post: 09-24-2009, 08:26 AM
  3. newbie questions
    By bigmac in forum Access
    Replies: 0
    Last Post: 10-07-2008, 12:53 AM
  4. newbie needs design help
    By ashiers in forum Database Design
    Replies: 0
    Last Post: 09-13-2008, 07:05 PM
  5. Newbie question
    By benplace in forum Queries
    Replies: 1
    Last Post: 12-13-2005, 06:40 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