I want to do a form that has a main-form,sub-form and a subsub-form.
Im using 3 tables: BorrowerCase,IndividualBorrower,Contact Party
BorrowerCase has a one to many relationship with individualborrower and individualborrower has one to many relationship with contactparty. In the main form, i want to add as many borrowers as i want and in the borrowers subform i want to add as many contact parties as i want.
Each of these tables has a auto-number ID. So how do i do it? I Read that microsoft access 2000 cant have subform with subform if you have a continous form but i really need to implement my form this way as i think its the most logical solution so any ideas??