inventory Query

  • Thread starter Thread starter Iris
  • Start date Start date
I

Iris

I have 2 tables. One "inventory" thhe fields are
PartNumber, QTY, Descrp. the other table "orders" have
the ability to order up to 6 Partnumbers for each row.
The fields are PartNumber1, QTY1, PartNumber2, QTY2,
etc. I am trying to put together a query that will tell
me if I have enough inventory for the orders.

HELP
 
Iris,

This problem is more difficult than necessary because of the structure
of the data. Is your table design set in concrete at this stage, or
could you consider a review? Basically, for correct database design,
the order details should be in one field in separate records in a
related table, rather than in separate fields in a single base table record.
 
Back
Top