Re: Subform, Join and View
Posted: Wed Jul 21, 2021 11:37 am
Ok, please let me know if something is unclear or if you have any questions.
Page 2 of 2
Re: Subform, Join and View
Posted: Wed Jul 21, 2021 3:59 pm
Ok. Many Thanks ... I let you know
Re: Subform, Join and View
Posted: Thu Jul 22, 2021 3:27 pm
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
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
Re: Subform, Join and View
Posted: Thu Jul 22, 2021 4:59 pm
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.