Table relationship

[Naqibullah]

Hi friends i have some confusion, i really appreciate your responses in advance
i have three tables named as member, loan and repayment in which relationships are as follow.....member to loan -one to many, member to repayment-one to many, and if i do data entry of loans and repayments of respective members ofcourse i have to add the respective members primary key in loan and repayment tables (i have also created forms for them) my question is, is there any why to create a form in which there three split forms member pre-entered data, and loan and repayment forms in two tabs when i select a specific woman in member table the respective primary key should be entered in loan or repayments forms so that there should be no need of entering the members primary key in loan and repayment form while data entry.
thank you all in advance

 

[Beetle]

is there any why to create a form in which there three split forms member pre-entered data, and loan and repayment forms in two tabs when i select a specific woman in member table the respective primary key should be entered in loan or repayments forms so that there should be no need of entering the members primary key in loan and repayment form while data entry.

Yes. It's called a sub form. When you use a Subform Control, the Master/Child link property automatically handles the insertion of the foreign key value when you add records in the sub form. You can set up a form like this with the wizard if you're not familiar with it.

 

[Naqibullah]

Thanks for your quick and valuable response!!!
i really appreciate if you kindly elaborate the process i will explain some of the process others you please.
in a new form on the top there is member form which is master form and on separate tabs there are two other forms loan and repayment assume i filter one specific member from top form which is member form, now how and where to set the code so that the master (member) primary key sits in loans or repayments forms in its specific fields as foreign key.
thanking you

 

[Beetle]

The Loan and Repayment forms should be sub forms on your main form. Sub forms are contained within a control called a Subform Control. The Subform Control has a Master/Child link property which controls the foreign key. See the illustrations in post #4 of this thread for a visual.

 

[Naqibullah]

ok got it ...thanks alot my problem solved