Page 1 of 2

subform - add a new record from the browse list

Posted: Mon Oct 17, 2022 2:15 pm
by yvesf
Hello,

I have created a form customer containing a subform Desktop. The aim of the application is to list the deployed desktops for a related customer.
On the home page I have a button customer and I can create from the customer form its related desktops one by one.

I have also created a second button on the home page called Desktop which lists all the deployed desktops by client.
When I clic on a row of this browse desktops' list, I open the related desktop form but I cannot see the related client in the form itself. How can I show this information as readonly information in the desktop form ? with a display field ?
Moreover, is there a way to create a new desktop record from this view by selecting the client first (select field) directly from the desktop form ?
Attached a video of a simplified project representing that here with questions at the end--> video (simplified project)
Many thanks for anyone that could help me.
Best regards,

Yves

Re: subform - add a new record from the subform

Posted: Mon Oct 17, 2022 3:41 pm
by kev1n
Would it be possible to upload some screenshots together with some annotations?
Then I might understand better how the forms are structured and which objects are used.

Re: subform - add a new record from the subform

Posted: Mon Oct 17, 2022 6:08 pm
by yvesf
I have updated the original request and added a video with questions in it --> https://we.tl/t-xHMMtjGLfH

Re: subform - add a new record from the subform

Posted: Mon Oct 17, 2022 9:00 pm
by yvesf
Here is the project zipped --> https://we.tl/t-PWUppdirTU
You just have to create the db part : a sql user dsk/dsk and database dsk
Many thanks for coming back to me if it needs clarification.
I would like to know how to show the parent record in the subform and how to add a new record from the browse subform by selecting the record parent first.
Many thx

Yves

Re: subform - add a new record from the browse list

Posted: Mon Oct 17, 2022 10:08 pm
by kev1n
It seems that the db dump (sql file) is not included in the zip file.

Re: subform - add a new record from the browse list

Posted: Mon Oct 17, 2022 11:20 pm
by yvesf
Here is the dump of the database --> https://we.tl/t-ohDTuEjhHm
BRegards,

Yves

Re: subform - add a new record from the browse list

Posted: Tue Oct 18, 2022 5:11 am
by kev1n
I don't think you can get around creating a new form: Clone the dsk form and change its type to a "Browse and Edit" form then add a display object as you suggested to show the customer.

Attached is the SQL to create the form "Customer_DSK".

Re: subform - add a new record from the browse list

Posted: Thu Oct 27, 2022 5:22 pm
by kev1n
Is this solved or do you still need our support?

Re: subform - add a new record from the browse list

Posted: Tue Nov 01, 2022 10:33 pm
by yvesf
I have removed contentbox finally. I don't finally understand if there is a context where you use subform as it is so limited ( no abiliy to add code for example).

Re: subform - add a new record from the browse list

Posted: Wed Nov 02, 2022 8:02 am
by kev1n
Well, a aubform lets you quickly enter, modify, delete data as you would in a spreadsheet.
The advantage over a browse form is that you do not have to open a record before you can edit it.
In addition, it allows you to paste data from e.g. Excel and to paste all data back to the clipboard.
It depends on the purpose of the application whether you want to use a subform or a browse (embedded iframe).