Subform, Join and View

Questions related to using nuBuilder Forte.

Re: Subform, Join and View

Unread postby kev1n » Wed Jul 21, 2021 7:07 pm

Ok, please let me know if something is unclear or if you have any questions.
kev1n
nuBuilder Team
 
Posts: 1996
Joined: Mon Oct 15, 2018 2:13 am
nuBuilder Version: 4.5

Re: Subform, Join and View

Unread postby BDemeuse » Wed Jul 21, 2021 11:29 pm

Ok. Many Thanks ... I let you know
BDemeuse
 
Posts: 20
Joined: Mon Apr 12, 2021 10:39 pm
nuBuilder Version: 4.5

Re: Subform, Join and View

Unread postby BDemeuse » Thu Jul 22, 2021 10:57 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
BDemeuse
 
Posts: 20
Joined: Mon Apr 12, 2021 10:39 pm
nuBuilder Version: 4.5

Re: Subform, Join and View

Unread postby kev1n » Fri Jul 23, 2021 12:29 am

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.
kev1n
nuBuilder Team
 
Posts: 1996
Joined: Mon Oct 15, 2018 2:13 am
nuBuilder Version: 4.5

Previous

Return to General

Who is online

Users browsing this forum: No registered users and 26 guests