Calling up cost prices

[odie123]

Hi

I have a table with the following fields: Description-- Cost Price
I have A 2nd db with the following fields: Description -- Cost Price--Qty.
I want to build a form using the two db [or any other suggest] where I use the description and the cost price gets automatically called up for that spescific stock item.

Hope this is clearer

Thanx
--------------= Posted using GrabIt =----------------
------= Binary Usenet downloading made easy =---------
-= Get GrabIt for free from http://www.shemes.com/ =-

[pietlinden]

odie123 wrote:

Hi

I have a table with the following fields: Description-- Cost Price
I have A 2nd db with the following fields: Description -- Cost Price--Qty.
I want to build a form using the two db [or any other suggest] where I use the description and the cost price gets automatically called up for that spescific stock item.

Hope this is clearer

Thanx

This design is screwed up. You should probably have something like

PRODUCT(
ProductID,
VendorID,
Description,
SalePrice)

INVOICE_LINEITEMS(
InvoiceNo,
ProductID,
Qty,
(Maybe Price)
)

If I were you, I'd spend some time tearing apart the NorthWind database.