Access Forms Drill Down
Posted on 2011-04-29
Looking at how to due the following.
Fields: RelationshipID - Primary Key (yes dupls)
LoanNo - Primary Key (no dupls)
Loan Information (Balance of various information fields in table)
Open this table in form view for editing.
Embedded into this form is the following form:
Field: RelationshipID-Primary Key (yes dupls)
LoanNo-Primary Key (yes dulps)
CollType-Primary Key (no dupls) This is a lookup field
I want to be able to lookup type collateral (ie motel, single family home, office building, etc). Then double click on this field and open up a detail to input collateral type detail.
For example if motel is the collateral and then double click in done the following form is opened.
Fields: AutoNo-Primary Key (no dupls)
RelationshipID-Primary Key (yes dupls)
LoanNo - Primary Key (yes dupls)
Motel Information (Balance of various information fields in table)
I need to open the MotelForm and 1st see if there is a RelationshipID match. If so then I need to see if there is a LoanNo match. Then pull those records into form view for editing or additional input.
If there is no RelationshipID match I need to add the RelationshipID as well as the LoanNo into form to allow addition of information..
If there is a RelationshipID but no LoanNo then I need to open and add new LoanNo and open form for addition of information.
I could have one LoanNo but it could have multiple collateral types ie- Motel, CD and Furniture & Fixtures. Additionally a LoanNo could have multiple collateral pieces. IE the loan could be secured with (3) motels.