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;