validating a stock item

validating a stock item

Post by jerem » Tue, 04 Nov 2003 21:54:21

I have a database which offers deals on stock items.
Whenever a new deal is oofered I want to write a
validation to ensure that the stock item is not sold.

I have a deals table and a stock table linked by stock ID

The code must open the deals table, there will be deals
listed here on a range of stock numbers. I need to check
all deals on each stock number and establish the value of
the [Sold} field in the table row for each one.

If the value shows that the stock item is sold then I will
add a msgBox to say so.

Can't figure the code to establish if the test is true

validating a stock item

Post by anonymou » Thu, 06 Nov 2003 03:32:41

Somehow this new question showed up as a response to my,
unrelated, question.