Hi,

I have the following situation in a site that I am currently working on. I have a small form with 2 fields, [Product Code] and [QTY]. This from inserts a record in one of my Access 2000 tables called tbl_Positions. When I insert the record into the database I need to validate the Qty in the 2nd field against the Field QTY_ALLOWED in a Table called tbl_Products.

Can some one please tell me if this is possible and more or less how I would go about accomplishing this.

Thanks
Dawie