Hi all,

Thought I'd try creating my first stored procedure for SQL, but don't know if what I'm thinking is posisble! so pls bear with me,

Say I've got 2 tables - tblCards and tblBatch.

tblBatch has BatchNo,DateDelivered,BatchQty,QtyUsed
tblCards has CardId, CardSerial, BatchNo, Issued, DateUsed

Say if a Card in tblCards has been updated to say Issued='Y' and DateUsed=whatever the date is, is it possible to automatically update tblBatch.QtyUsed where the card is associated with?

Hope this makes sense.

Any help is much appreciated

Greyskull