Results 1 to 2 of 2
  1. #1
    Wrangler is offline Wrangler
    Windows 7 Access 2007
    Join Date
    Dec 2005
    Location
    Alabama
    Posts
    17

    All Data wont show

    I have two tables, Products and Order Details. I am using a query to bring the two together. I am using a one-to-many relationship with ProductID being the primary in products and OrderID in Order details with a foriegn key of ProductID. I can use a combbox and select a product and is shows the product and cost but it will not show any other data fields.



    here is the SQL code. can anyone help?

    SELECT [Order Details].OrderID, [Order Details].productID, Products.ProductName, [Order Details].Cost, [Order Details].sell, [Order Details].UnitPrice, [Order Details].quantity, [Order Details].discount, CCur([Order Details].UnitPrice*[Quantity]) AS ExtendedPrice
    FROM Products INNER JOIN [Order Details] ON Products.ProductID = [Order Details].productID
    ORDER BY [Order Details].OrderID;

  2. #2
    Wrangler is offline Wrangler
    Windows 7 Access 2007
    Join Date
    Dec 2005
    Location
    Alabama
    Posts
    17

    Got it to work using VB

    I had to have the fields for the form update using VB all is well now.

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

Similar Threads

  1. Data won't show up in table field
    By texzen123 in forum Forms
    Replies: 3
    Last Post: 11-26-2009, 11:20 AM
  2. Replies: 4
    Last Post: 10-29-2008, 11:53 AM
  3. drop down wont display
    By gromit95 in forum Database Design
    Replies: 3
    Last Post: 10-21-2008, 11:12 AM
  4. Show some or all
    By protean_being in forum Queries
    Replies: 1
    Last Post: 05-28-2008, 05:33 PM
  5. Replies: 0
    Last Post: 08-30-2006, 02:50 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
  •  
Other Forums: Microsoft Office Forums