Two database query/table help

[KenshiroUK]

Okay my boss currently has a database called new orders and that works fine. I am working on another Database called Inventory and basically I need to create 2 queries from Inventory that looks for new orders in 'New Orders' DB and deducts the stock numbers from 'Inventory' Database.

Would anybody have some good ideas how I would go about doing this?

 

[Trevor G]

First you need to get the query in from the other database so you would use a MACRO to transferDatabase then you can select the query, or you could add another query to make a table from the query and then you can link that table into your Inventory database.

Without giving anything specific in your thread as headings in the database it isn't easy to suggest how you can compare one table against another from different databases.

 

[KenshiroUK]

First you need to get the query in from the other database so you would use a MACRO to transferDatabase then you can select the query, or you could add another query to make a table from the query and then you can link that table into your Inventory database.

Without giving anything specific in your thread as headings in the database it isn't easy to suggest how you can compare one table against another from different databases.

Okay in my Inventory DB we have headings such as SKU, Standard Product ID, MFR-part-number, Count (which is product quantity and this is the sections where numbers will be deducted) and finally Item Price.

In the Orders DB we have Order ID, Order Item ID, SKU, Price.

So I'm looking to create a query or a couple of queries that picks up on that SKU code on New Orders DB and deducts it 1 from Count in my Inventory file.