I have a 2 tables that contains the following fields:
LineTable
id
qty_ordered
item
due_date

RecvTable
id
qty_recv
item
recv_date

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.

Any help would be greatly appreciated.
Craig