Urgent Question about creating relationships among tables

[xwnoob]

Hi people, I have been pondering over this matter for awhile and i still cant find a solution so i hope they you all have one. So i am new to access and i have done some self studying on my own about design basic and normalisation(although i wont following this strictly due to the nature of this database im about to build) and i understand the concepts but i cant apply this to my database. Here is the case: My database has 9 tables: Borrower Detail,Roles and Doc,Type of Security, Repayment,fee,checklist,regulatory submission,majority lenders,required accounts. The thing about this database is that i want all the tables to be dependent only on borrower details (e.g without borrower details, there will be no info in any tables). It is a one-to-many relationship with one being the borrower detail table and many being either of the remaining 8 tables. So the way i want to enter information in this database is using a form. First i will enter new borrower details in a form and then i will enter info into the rest of the tables(also using forms) based on each new record i entered .So can you give me a clear solution on how to define the relationship properly and also how can i add info in the 8 tables in such a way that the info i entered will be based on a specific borrower record.(e.g. in the Roles and Doc form, i will select the borrower ID first so that Access understand the info will be linked to this specific ID).

[pbaldy]

In general, in the relationships window you can set referential integrity, which will enforce the rule about a borrower detail record being required. In forms, you'd use a form/subform where the form is based on the borrower detail table and the subform on one of the others. Master/child links on the borrower detail ID will keep them in sync with each other.

[A S MANN]

See the Attached DB as sample DB in 2003 version
Create a form
add Master Table as borrower detail as primary source
add other as Subform one by one linking it to main Table as shown in Main Form
In the same manner add the other subform in the form
Hope this will solve your issue

[RayMilhon]

Also look at the Tab Control for your main form. Each Tab can be linked to a specific subform and makes it easier on the user to get to the data they need.