inventory Query

[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

 

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