Subform, Join and View

[kev1n]

Ok, please let me know if something is unclear or if you have any questions.

[BDemeuse]

Ok. Many Thanks ... I let you know

[BDemeuse]

Hi,

I have tried to understand but
First of all, what are the forms to manage ?

Browse&Edit form on the 'tr_membre' with a subform for 'tr_contact' ?
On this assumption, the foreign key is not the appropriate one (so, error message in any case)
You mentioned 'number object' and 'object id' ... but I do not undersand

Or the solution you propose is based on the browse&edit form of the view (joining the 3 tables).

A simple solution (according to my knowledge level), is to separate the management of both concept tr_membre and tr_contact and to simply add a button to the browse&edit tr_membre to switch to browse&edit tr_contact... but it is less user friendly.

Many Thanks,

Regards,

Bri

[kev1n]

My solution is to add some extra objects to the form that are not part of the table and load/save them with PHP separately.