subform on a subform

[steve foley]

I have three tables; matters, events, activities. Each matter may have multiple events, and each event may have multiple activities.

I have a form set up for matters with events as a sub form (grid). I have form set up for events with activities set up as a subform (grid).

Ideally, I'd like to have the activities subform set up as a subform to the events subform.

I also tried adding a button to the events subform to open the events form, but can't figure how to find the correct record. I've tried using #id# , #record_id#, event_id, in the "Record ID" on the "Button" tab of the button. The only way I've gotten this to open an actual event is if I key in the actual contents of the field matter_id into the "Record ID".

Is there a way to accomplish this?

[bike3926]

Hi Steve

I think you should change your approach to the problem: you can create a browse events form, choose the matter from a dropdown box and using only one subform for activities.... perhaps the easy way

Ciao

Max

[steve foley]

I'm doing something similar as an interim solution.

I have a form set up for events, and there is a lookup for matters. Using this method, I can add an event, and using the lookup, add the (parent) matter along with everything associated with the matter. When I close the matter form, I can continue on with the event form and add the activities in the subform.

If I could figure out a way to open and edit the (parent) matter form, I'd be done.

[admin]

Steve,

I had a go at answering your question here..

http://forums.nubuilder.cloud/viewtopic.p ... 521#p13907

Steven