help with a table

[rgaw22]

I have a table which I added data to on daily basis, one column has serials number in, what I would like to is to be able to link that column with another table which is a linked table to a stock list and for it to tell me it have I not taken that item of stock.

hoppy that all makes sence

 

[KenReay]

Hi

Assuming:
the first table you mention is the Stock Issues table (tblIssues)
the second table is the stock items table (tblStockItems
the serial number is the unique identified of the stock item

SELECT * FROm tblStockItems WHERE SerialNo NOT IN (SELECT SeriallNo FROM tblIssues)

using you own table and column naems of course

will do it


Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK