Form linking question...

[TCARPENTER]

Hi All,

I have a main form A with a sub form B, and B has a subform C sort of like this:

________________________________________________
| A |
| ____________________________________________ |
| | B | |
| | ________________________________________ | |
| | | C | | |
| | |________________________________________| | |
| |____________________________________________| |
|________________________________________________|

My question is with linking, B is linked to A and C is linked to B,A: When I move a record in A, B and C follow - no problem, but when I move B, C gets left behind. I thought the linking of forms/sub-forms was supposed to handle this or is this just when adding records? Is this too complex? I'm asking because I know I could write code to handle this, I just want to be sure I didn't overlook something or do something wrong.

Thanks
Todd

 

[PHV]

For me, C should be linked to B only ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[TCARPENTER]

Hmm..

Could be...

C is a join table use the id from A (and one from C) and optionally a record from B. Maybe I sould redo this?

Todd