Nested record Loaders? Master detail forms

Hi,

Is it possible to use the controls to build a master detail form?

I have a table with fields (amongst other things) id, idConvener,idAdministrator. That table is loaded with a multi-record loader. The fields idConvener,idAdministrator point to separate tables and I can in code pick other fields from those using a multi-record loader based on those keys idConvener,idAdministrator, of course.

Can one nest db record loaders into the multi-record loader 'on record found' action and for each of the records picked in the multi-record loader read the corresponding single records via the db record loader? If you can, how do you make the connection between the keys in that case?

And then can one add a custom code into that same 'on record found' to display a message detail?

Does that make sense? I have tried it and can't quite pull it together. 🤨

Hi Nick,

I'm far from sure I understand your description but this sounds as though you want to make a query using MySQL joins to build a 'record' from several tables. If so this is quite possible though a little picky to get all the settings correct.

You could also use more DB Record Loaders after a DB Multi-Record Loader but I'm not sure that would do what you want.

Bob

Hi Bob,

Damn - that was quick! I will see if I can sketch out what I mean later. I think that what I need is pushing chronoforms a bit too far!

Incidentally I have just installed the latest Chronoform on my 1.5 site and it works fine. My 1.7 site was already there. My dynamic record problems are sorted.

Nick