subform - add a new record from the browse list

[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

[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.

[yvesf]

I have updated the original request and added a video with questions in it --> https://we.tl/t-xHMMtjGLfH

[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

[kev1n]

It seems that the db dump (sql file) is not included in the zip file.

[yvesf]

Here is the dump of the database --> https://we.tl/t-ohDTuEjhHm
BRegards,

Yves

[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".

[kev1n]

Is this solved or do you still need our support?

[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).

[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).