display children in parent form

[la_saucisse]

Hi,

This my 1rst thread here, and excuse my english, I'm french.
I discovered FormTools today and I think I'll use it for many things.

But actually, after many tests, I'm stuck on something...

_____________________
FORM 1 : Companies
Name, adresses, phone number...

FORM 2 : People that work in this companies
Name, email, phone... and its company, selectable with a Dropdowns list linked to the FORM 1 "Name" field.
_____________________

so far, it's work : Company is the "parent" form, People is the "child" form, and each record in People is linked to one Company.

My problem : while displaying a View of a "Companies", I'd like to display all about a campany (name, adresse...), but also a list of all peoples that working for it.

to summarize : I need a subform that display some FORM 2 fields in a FORM 1 view...

Is it possible, and how ??
thanks a lot in advance,
@la_saucisse

[la_saucisse]

heeeelp !!!

...or no way to do this ??

[alexh]

I think I understand what you are trying to do. If you are looking for a way to view submissions from two different forms at the same time, it's not possible with formtools. You would have to build a custom script to pull the data from the database and display it on a page. It's possible, but will take some programming.

[la_saucisse]

hi,

I thinked FormTools was a kind of "online Access-like", that allow complexes relations between tables.
well, I'll try do make my "app" without those relations, but... I think I'll have to find something else !

thanks for your answer !

[la_saucisse]

finally, this thread isn't (yet) closed ^^

I just discovered the "Code Hook" plugin, that allow to apply some php scripts in conditions : before, after... it's a really fantastic tool for customize the script !

so, while laoding a form view, it may be possible to apply a DB request to fill a (textarea) field with the "children" form values, with exact tables ID...? may be ? I'll try and tell you the results !