I have a 2 tables that contains the following fields:
I need to create another table that contains receipt tranactions for the above table. For instance, if someone orders a qty of 3, they may receive that in on 3 different days. (qty of 1 for each receipt). These receipts are going to be entered in a form. I can create the other table, but I can't figure out how to limit the qty_rec'v to <= qty_ordered.