Hi, I do not receive any suggestions about my topic. I think: is it impossible or very difficult ?
I verified also thinking useful "select dinamic cascade". It can help me but I think do not much. This is the reason.
You have to think that I can have many thousand of records in my table.
For each city I can have the same firm name also 3-4 times (in truth the companies that I call "firms" are institutions).
At this point which I choose? I can choose only if I read address firm.
Therefore I ask you, please: Is there a way to see others fields about my main table, using "select dinamic cascade" or "select dinamic fields", for doing a sure choose ? I hope to be clear about my problem that I expose.
Many thanks in advance for your reply. Best regards, Louis

Hi,

you could use Select Dynamic Free option to construct a query with joins that would show adress next to company name, but it depends on your field storages

Dear Klas, thanks for your reply.
I need your help for some istructions to insert in SQL query in case of free options.
Follow me, please, : I create a simple form ( definitive form will be realized later ) with some fields.
You find the form at the following address: http://regionesiciliana.altervista.org/index.php/purchases
If you see on the right there are some fields in output. These fields are present together in the record about institution name.
Therefore, when I choose istitution name ( see you, please,  "lista anagrafica" on the left ), I need to see other fields on the right of the form about istitution that are: zipcode, city, address etc... . 
Hope to be clear for you. I need surely your better help.  Awaiting your reply. Thanks again, best regards, Louis

Dear Klas, have you any news for me ? I try about your suggestions, but I think is wrong anything because I do not see further fields about company.
Could you guide step by step ? First thing: what storage I have to use for my fields ? Actually I use standard storage and I create all fields with close padlock. Did I well ?
I will be in await about your reply.  Regards, Louis  

Hi,

You can read about storage here http://www.seblod.com/resources/tutorials/how-to-manage-fields-storage - this should give you information which tables you need to query to get the right value, but you will need to construct query yourself, we can only give you general directions.

Dear Klas, many thanks. I will read the link about data storage and inform you soon. Regards, Louis

Caro Luigi,

Una delle soluzioni molto semplice sarebbe usare il Article (Related) campo per selezionare la azienda nei dati del acquisto.
La opzione che devi scegliere per mostrare i dati della azienda (nel Intro, Content oppure Item nel list view) è Display (Parent) e li scegli intro.

Questa soluzione non visualizza i dati della azienda durante la fase del editing, pero i dati della azienda si vedranno nel intro.

Se invecie quello che vuoi è avere la ditta visualizzata imediatamente, una mezza idea la avrei, ma devo prima provare.

Saluti,
Alessandro

Ciao Alex, grazie per il tempo che mi dedichi. Se vuoi possiamo sentirci in privato a mezzo mail, oppure inviami un tuo suggerimento rispondendo a questo post. Quello di cui ho bisogno è la possibilità di verificare con certezza l'identità dell'azienda. Fammi sapere, grazie ancora, saluti, Luigi