Plugging a primary key into a foreign key field of another table

[Jay]

What I have is this, I have three tables and forms; (1) the main table behind
the parent form, (2) the secondary table behind first level a child form
(embedded) set to "Continuous Forms" taking it foreign key value from the
main (Parent) form primary key. Now the (3) third (sub_subform) grandchild
form also set to "Continuous Form" must get it's foreign key plugged from the
second (child) form's primary key, thus allowing the third form (grandchild)
to list multiple records linked back to the child form record primary key.
The problem is this, the (3) form or grandchild form is a pop-up form. So,
there is not a direct parent child link between form (2) and form (3). Is
there a method or better put; "What is the best solution or possible option
in this case?"

I hope that I was as clear as possible, in what I'm attempting to do. If
there are question, please ask. I've been looking around for a solution and
have yet to find one!

Your input will be appreciated.

Thanks,

 

[RuralGuy]

What I have is this, I have three tables and forms; (1) the main table behind
the parent form, (2) the secondary table behind first level a child form
(embedded) set to "Continuous Forms" taking it foreign key value from the
main (Parent) form primary key. Now the (3) third (sub_subform) grandchild
form also set to "Continuous Form" must get it's foreign key plugged from the
second (child) form's primary key, thus allowing the third form (grandchild)
to list multiple records linked back to the child form record primary key.
The problem is this, the (3) form or grandchild form is a pop-up form. So,
there is not a direct parent child link between form (2) and form (3). Is
there a method or better put; "What is the best solution or possible option
in this case?"

I hope that I was as clear as possible, in what I'm attempting to do. If
there are question, please ask. I've been looking around for a solution and
have yet to find one!

Your input will be appreciated.

Thanks,

When you open the PopUp, pass the info you need in the OpenArgs
parameter or use the WhereCondition parameter.
_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.

 

[Jay]

Thanks RuralGuy:

Please provide an example of what you indicate as a solution. Remember, the
subform Child form as well as the grandchild form are set to "Continuous
Forms". Only that the grandchild should be keyd to each record of the child
form showing multiple records. Two "Continuous Forms" cannot be embedded into
each other such as subform and sub_subform. This is why I chose to use a
pop-up for what would have been the embedded grandchild form within the child
form. Intheory is should work, I guess> Shouldn't it?

It may be too complex, if it is, let me know!

 

[RuralGuy]

Jay,

To display a Continuous form as a SubForm of a Continuous form you
simply put them side by side as SubForms of another form. Place a
hidden TextBox on the Main form with it's ControlSource set to
=SubForm1.Form.KeyForTheOtherSubForm then point the Link Master
Field to this TextBox for SubForm2.

Why don't you post how you are opening the GrandChild form currently
and then I could show you how to modify it for my original suggestion.

Thanks RuralGuy:

Please provide an example of what you indicate as a solution. Remember, the
subform Child form as well as the grandchild form are set to "Continuous
Forms". Only that the grandchild should be keyd to each record of the child
form showing multiple records. Two "Continuous Forms" cannot be embedded into
each other such as subform and sub_subform. This is why I chose to use a
pop-up for what would have been the embedded grandchild form within the child
form. Intheory is should work, I guess> Shouldn't it?

It may be too complex, if it is, let me know!

_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.

 

[Jay]

Thanks again RuralGuy:

Well,...where shall I begin. I have a main form (A) which list the customer
details, then, list or allows by data enrty the main product purchased in the
child form (B) by line item. Then, in the sub_sub_form (C) grandchild
sub_form allows data entry of a breakdown of various items making up the main
line item on child form (B). I wanted to have sub_sub_form (C) grandchild to
be a pop-up to facilitate the process of data entry of multiple items within
the line item in sub_form (B), it looked cleaner, I thought! Maybe, not,
however, that was the approach I was taking. If you have a better suggestion
or idea, I'm open to it! Keeping in mind that I need to have it all look and
feel clean in the end!

I appreciate your input on this matter. I guess that's why we have this
forum, to bounce ideas off of one another.

Thanks again!

Jay,

To display a Continuous form as a SubForm of a Continuous form you
simply put them side by side as SubForms of another form. Place a
hidden TextBox on the Main form with it's ControlSource set to
=SubForm1.Form.KeyForTheOtherSubForm then point the Link Master
Field to this TextBox for SubForm2.

Why don't you post how you are opening the GrandChild form currently
and then I could show you how to modify it for my original suggestion.

Thanks RuralGuy:

Please provide an example of what you indicate as a solution. Remember, the
subform Child form as well as the grandchild form are set to "Continuous
Forms". Only that the grandchild should be keyd to each record of the child
form showing multiple records. Two "Continuous Forms" cannot be embedded into
each other such as subform and sub_subform. This is why I chose to use a
pop-up for what would have been the embedded grandchild form within the child
form. Intheory is should work, I guess> Shouldn't it?

It may be too complex, if it is, let me know!

_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.

 

[RuralGuy]

It sounds as though you have not attempted anything yet. For your own
sake you should put something together that sort of prototypes what
you had in mind. To have it "look and feel clean" is really very
subjective. Only you can answer that question. Use the wizards to
open forms and define forms as much as you can. Once you have
something to look at and play with you can decide for yourself if it
will satisfy your requirements. I can answer specific questions about
problems you might run into and how to resolve them but the design is
yours. VBA that comes with Access is complete and as such will allow
you do do anything you want. If you can think it up, you could
probably implement it in Access. The only difference between each
method of implementation is the look and feel and the amount of code
required to make it happen. Post back if you have a specific question
and I or someone else will try to answer it.

Thanks again RuralGuy:

Well,...where shall I begin. I have a main form (A) which list the customer
details, then, list or allows by data enrty the main product purchased in the
child form (B) by line item. Then, in the sub_sub_form (C) grandchild
sub_form allows data entry of a breakdown of various items making up the main
line item on child form (B). I wanted to have sub_sub_form (C) grandchild to
be a pop-up to facilitate the process of data entry of multiple items within
the line item in sub_form (B), it looked cleaner, I thought! Maybe, not,
however, that was the approach I was taking. If you have a better suggestion
or idea, I'm open to it! Keeping in mind that I need to have it all look and
feel clean in the end!

I appreciate your input on this matter. I guess that's why we have this
forum, to bounce ideas off of one another.

Thanks again!

Jay,

To display a Continuous form as a SubForm of a Continuous form you
simply put them side by side as SubForms of another form. Place a
hidden TextBox on the Main form with it's ControlSource set to
=SubForm1.Form.KeyForTheOtherSubForm then point the Link Master
Field to this TextBox for SubForm2.

Why don't you post how you are opening the GrandChild form currently
and then I could show you how to modify it for my original suggestion.

Thanks RuralGuy:

Please provide an example of what you indicate as a solution. Remember, the
subform Child form as well as the grandchild form are set to "Continuous
Forms". Only that the grandchild should be keyd to each record of the child
form showing multiple records. Two "Continuous Forms" cannot be embedded into
each other such as subform and sub_subform. This is why I chose to use a
pop-up for what would have been the embedded grandchild form within the child
form. Intheory is should work, I guess> Shouldn't it?

It may be too complex, if it is, let me know!

:

On Thu, 25 Aug 2005 11:08:03 -0700, Jay

What I have is this, I have three tables and forms; (1) the main table behind
the parent form, (2) the secondary table behind first level a child form
(embedded) set to "Continuous Forms" taking it foreign key value from the
main (Parent) form primary key. Now the (3) third (sub_subform) grandchild
form also set to "Continuous Form" must get it's foreign key plugged from the
second (child) form's primary key, thus allowing the third form (grandchild)
to list multiple records linked back to the child form record primary key.
The problem is this, the (3) form or grandchild form is a pop-up form. So,
there is not a direct parent child link between form (2) and form (3). Is
there a method or better put; "What is the best solution or possible option
in this case?"

I hope that I was as clear as possible, in what I'm attempting to do. If
there are question, please ask. I've been looking around for a solution and
have yet to find one!

Your input will be appreciated.

Thanks,

When you open the PopUp, pass the info you need in the OpenArgs
parameter or use the WhereCondition parameter.
_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.

_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.

_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.