inventory Query

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
 
S

Steve Schapel

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.
 
Top