Subform

[sajitk]

Hi,

I have 2 tables namely:

Beneficiary

Solar Lantern No - Pkey
Benficiary Name 
Cost

Payment 
Solar Lantern - Fkey
Payment - the payment can be made in installments
Payment date

I have a form which has a subform named (beneficiary dts) which displays all the beneficiary details. Now wat i want is that, when the user clicks on a particular record in the subform beneficiary dts, the corresponding payment details should be displayed in the another subform (payment dtls)

thanks
Sajit

[mshmyob]

Your main form should display the Benificiary Name and cost and your subform should be displaying the payment details.

I also assume you forgot to show the primary key in your payment table.

cheers,

Hi,

I have 2 tables namely:

Beneficiary

Solar Lantern No - Pkey
Benficiary Name 
Cost

Payment 
Solar Lantern - Fkey
Payment - the payment can be made in installments
Payment date

I have a form which has a subform named (beneficiary dts) which displays all the beneficiary details. Now wat i want is that, when the user clicks on a particular record in the subform beneficiary dts, the corresponding payment details should be displayed in the another subform (payment dtls)

thanks
Sajit