S
SDIrby
Good Morning all,
I hope everyone enjoyed their easter, and now for business.
I have a recordset based off of Loan numbers. ITs for holdin
different document statuses and types. The thing is, that i need t
limit the type of document that can be stored in a field with that loa
number. For instance, if loan number "11111" has the document "TP
once, it cannot have it again. BUT, it's status "sent","Received"," O
"Accepted" can be changed in that recordset.
Also, there is one document that CAN appear multiple times. "ASSN" ma
appear more than one for each loan number.
So in conclusion, the basics of it are.
I have a recordset based off of loan numbers. Each loan number ca
have only 1 "TP" and "MTG", but can have multiple "ASSN"'s. I need t
know how to limit this in a recordset. Thank you.
p.s. I hope it's not confusing. It is to me. lo
I hope everyone enjoyed their easter, and now for business.
I have a recordset based off of Loan numbers. ITs for holdin
different document statuses and types. The thing is, that i need t
limit the type of document that can be stored in a field with that loa
number. For instance, if loan number "11111" has the document "TP
once, it cannot have it again. BUT, it's status "sent","Received"," O
"Accepted" can be changed in that recordset.
Also, there is one document that CAN appear multiple times. "ASSN" ma
appear more than one for each loan number.
So in conclusion, the basics of it are.
I have a recordset based off of loan numbers. Each loan number ca
have only 1 "TP" and "MTG", but can have multiple "ASSN"'s. I need t
know how to limit this in a recordset. Thank you.
p.s. I hope it's not confusing. It is to me. lo