Help with multiple table queries

L

laser02910

I have an Ordersfrm with a subform based on a 2 table query which works fine.
Now I'm trying to add to the subform the ability to select a product serial #
if there is one for that specific product. Most products don't have one but
it's crucial the parts that do for service and warranty tracking issues. My
tables are as follows:

Inventory Transactions Table
TransactionID
ProductID
OrderID
PurchaseOrderID
ServiceID
TransactionDate
Warranty
TransactionDescription
UnitPrice
Discount
UnitsOrdered
UnitsRecieved
UnitsSold
UnitsServicedOut
UnitsServicedIn
UnitsWarrantyOut
UnitsWarrantyIn
UnitsShrinkage

Products Table
ProductName
ProductDescription
SupplierID
UnitPrice
UnitsInStock
UnitsOnOrder
ReorderLevel
Discontinued

Product Details Table
ProductDetailsID
ProductID
DateIn
SerialNumber
ProductDetailsNotes

My final query has to have the OrderID, ProductID, UnitPrice, UnitsSold, and
Discount fields from the Inventory Transactions Table with the ProductName
from the Products Table and the SerialNumber field from the ProductDetails
Table. Is this possible and/or am I giong about it the wrong way?
 
M

[MVP] S.Clark

For something that so closely resembles Northwind, you may want to log a
couple of hours with the example database to see how they do it.
 
L

laser02910

I have spent much more than a few hours with Northwind trying to modify their
examples but that database only uses 2 tables for the subform. I'm using 3. I
have to have a product details table seperate from the Inventory Transactions
table and the products table. Not all parts have serial numbers. Where is
there an example to create a three (or more) table query. Everytime I try, i
get a query that doesn't work.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top