Hi !

I would like to know if it is possible to retrieve data from a table from a dynamic selection field.

I have a table named "Produits et services" where I store information about my services sold. There is the name of the service, its usual price and the time it lasts.

When I create invoices, I use an intermediate tablenamed "Services facturés" in which I enter the information of the service sold. I start by selecting the service using a dynamic selection field.

This dynamic selection field allows me to obtain the name of the service (designation). I would have liked the "Durée" and "Prix uniaire" text fields to be automatically completed with information from the "Durée" and "Prix HT" fields of the linked record in the "Produits et services" table.

Knowing that the text fields are pre-filled but that I must be able to modify them (to adjust the real time of the "durée" field).

Is it possible ? If not, is there a workaround to achieve this?

Thank you for your help.