reference between table is not a list

[Fa1con74]

I want my inter-table reference not to be a list.

That is to say that the reference is automatic.
I have a "Building" table and an "Ebras". When a user fills in my "Building" table with a form when he saves, the "Ebras" form opens and I would like the reference of the building sheet that has just been entered to be included in my "Ebras" record for the bind
Is it possible if so how?

Thank you

[Suvrutt_Gurjar]

Please take a look at the following sample app if it helps.

https://www.appsheet.com/templates/How-to-use-nested-forms?appGuidString=d6cfb54e-80c3-461f-971f-8d6...

You need to make "IsPartOf" rleationship on in the reference column in the child table. Please read the description carefully of this setting.

If you do not wish the "IsPartOf" functionality to be on. You could use LINKTOFORM() deep link.

[Fa1con74]

Can I abuse your knowledge on a question more or less related to the subject?
Now that my inter-table reference works, how can I retrieve the value of my "Final classification" field from my "Ebras" table in the "Classification" field from my "Building" table?

Ebras[Batiments].Ebras[Classification finale]

I put this formula but it doesn't work 😞 , Knowing that this field must be updated once the Ebras form has been completed

[Suvrutt_Gurjar]

Could you you clarify whether you wish to populate the field in the Ebras table or in the "Bildings" table? It is somehow not clear from your description.

[Fa1con74]

I want the "Classification" field of my "Building" table to be filled in automatically with the content of my "Final classification" field of my "Ebras" table.
Knowing that my application works this way: the user must first fill in the form of my "Building" table and then that of my "Ebras" table

[Suvrutt_Gurjar]

Please take a look at dereference expressions. 

Generally your expression will be [Ref Column Name in Ebras Table].[Classification] 

https://help.appsheet.com/en/articles/1090811-dereference-expressions