Subform in a Subform, in a Form Help!

[rlh777]

I have a form that contains a subform. They have a field of RCustomerID in common. Everytime I select a customer on the form and click on the subform to add data, it updates fine. Now I want to take it a step further. I want to add another subform into the original subform. Now I have a Form, with a subform, with a subform inside of it. I select a customer and add information to the subform,(updates fine) then I select the "new" subform and add to it, but it won't update the RCustomerID. Therefore, my table has the information, but no ID. BTW...the RCustomerID is not the primary key on either subform. They have their own autonumber id's. Also, there are relationships built between all. Any thoughts?

 

[rlh777]

NM...I fixed it! Thanks anyway.

 

[rlh777]

My forms were not linked on their properties to the proper link field. Changed them both to RCustomerID and they work great!

 

[JeremyNYC]

My thought is that in seven years of building databases I've never once built a form within a form within a form. I don't think it makes sense for users. I would look for another solution.

Jeremy ==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Affordable Development, Professionally Done

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.