Hi Every one.
Nice weekend.
May some one can help for the below requirements.
TblTransaction
TrnNo (PK)
Date
GoodQty
RejectQty
Reason1 (Reject Reasons from 1- others)
Reason2
Reason3
Reason4
Others
There is a main form "FrmTransactions" to input the required data whereas if there is any rejected qty and entered any value in rejectqty field then a subform "SfrmRejects" shall popup to allow for the entry of reasons as fields are given above.
and also the the total qty given in reject reason fields should be always equal to the qty in "RejectQty" if any.
Kindly advise.