Page 2 of 2

Re: Subform, Join and View

Unread postPosted: Wed Jul 21, 2021 7:07 pm
by kev1n
Ok, please let me know if something is unclear or if you have any questions.

Re: Subform, Join and View

Unread postPosted: Wed Jul 21, 2021 11:29 pm
by BDemeuse
Ok. Many Thanks ... I let you know

Re: Subform, Join and View

Unread postPosted: Thu Jul 22, 2021 10:57 pm
by 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

Re: Subform, Join and View

Unread postPosted: Fri Jul 23, 2021 12:29 am
by 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.