By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,475 Members | 1,372 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,475 IT Pros & Developers. It's quick & easy.

Subform

P: 77
Hi,

I have 2 tables namely:

Expand|Select|Wrap|Line Numbers
  1. Beneficiary
Expand|Select|Wrap|Line Numbers
  1. Solar Lantern No - Pkey
  2. Benficiary Name 
  3. Cost 
Expand|Select|Wrap|Line Numbers
  1. Payment 
  2. Solar Lantern - Fkey
  3. Payment - the payment can be made in installments
  4. 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
Mar 19 '08 #1
Share this Question
Share on Google+
1 Reply


mshmyob
Expert 100+
P: 903
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:

Expand|Select|Wrap|Line Numbers
  1. Beneficiary
Expand|Select|Wrap|Line Numbers
  1. Solar Lantern No - Pkey
  2. Benficiary Name 
  3. Cost 
Expand|Select|Wrap|Line Numbers
  1. Payment 
  2. Solar Lantern - Fkey
  3. Payment - the payment can be made in installments
  4. 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
Mar 19 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.