Results 1 to 4 of 4
  1. #1
    burrina's Avatar
    burrina is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383

    Having Problem With New Inventory ADD Feature,Blank Records,DLookup Not Right

    I have finished about half the db for Inventory and Purchase Orders. With my brain, that's impressive!
    I am using the same Products table to reference on for Inventory.

    I don't believe my Relationships are correct since my Table does not display the correct data.

    The Form I am using uses both the Products table and the OrderDetails table and together they can show me everything.

    Trying to use 2 different form to both add and subtract from Inventory.
    Subtract works fine and shows what the customer has bought and all.



    Purchasing, i.e. Buying Products has proved a challenge for me.

    I thought that if the relationships were correct, when you added 2 or more tables, they linked by themselves?
    If you change the relationship in a query, does it then change it in the Relationships?
    Attached Thumbnails Attached Thumbnails Relationships.jpg   QueryForProblemForm.jpg   ProductsTableAfterUpdate.jpg  

  2. #2
    Rod is offline Expert
    Windows 7 32bit Access 2007
    Join Date
    Jun 2011
    Location
    Metro Manila, Philippines
    Posts
    679
    If you change the relationship in a query, does it then change it in the Relationships?
    No, they are entirely separate things: tables are related such that the RDMS (relational database manager) may ensure data integrity. Tables are joined in a query for the purpose of interrogating and retrieveing the data. Access uses the db relationship (if any) to suggest a join when first designing a query but you may change or delete that suggested join; you may also add joins where associated relationships do not occur in the db.

    I'll now take a look at the wrong concern.

  3. #3
    Rod is offline Expert
    Windows 7 32bit Access 2007
    Join Date
    Jun 2011
    Location
    Metro Manila, Philippines
    Posts
    679
    The join in your query looks very suspicious! Do you really mean to join OrderID to ProductID?

    I notice a questionable construct in your db design. You have in your OrderStatus table the ID, OrderID(?) and Status. Normally I would expect only the ID and Status to be in the table with the ID being included in the Order table as a foreign key.

  4. #4
    burrina's Avatar
    burrina is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383
    That would be that I need to track the status of each order is why!
    It is done this way because of my need to run Reports with that criteria.

    Thanks,

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

Similar Threads

  1. Appending inventory records with current price records
    By sberti in forum Database Design
    Replies: 8
    Last Post: 11-29-2012, 10:24 PM
  2. Blank Records in Table
    By anwaar in forum Access
    Replies: 3
    Last Post: 09-02-2011, 02:18 PM
  3. Production and Inventory Problem
    By jmorse in forum Access
    Replies: 2
    Last Post: 02-24-2011, 10:07 AM
  4. Inventory Query Problem
    By 1943 in forum Access
    Replies: 6
    Last Post: 02-13-2011, 09:05 AM
  5. Sorting Blank Records
    By vicky464 in forum Reports
    Replies: 6
    Last Post: 12-29-2010, 10:41 AM

Tags for this Thread

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