Hello everyone and thank you for your contribution.
I was wondering how the following could be done because i reach to “exclamation mark” notice 
.
I set a field in a table (A) as ref to another table (B).
The purpose of this is to have the ability to show the “Add” ability in the dropdown menu of the form.
My actuall purpose is to access collumn from table (C) which has ref to (B) .
I have done it with ANY(LIST(Select … but i get exclamation marks .
Any thoughts ?
Your expression is not pointing to the key of referenced table. Change to Select(Table**[Key]**…
in the Suggested values or in the Valid if of the ref type collumn (which has dropdown input mode) ?
Suggested values.
If you show me your expression would be better
In Partner_Vendor Table : An Organization is Unique
In Partner Accounts table: Organization_ID refers to Partner_Vendor Table.
An Organization has many (or may have) many Partner Accounts records.
In Sponsorship table: I want in the Partner field to be Ref to the Partner_Vendor table in order to be able (if there is no such record in the dropdown) to add it.
But i want Partner text field (from Partner Accounts) to be the value which will be showed.
The best i can do is that. In suggested Values returns error “The type of the Suggested Values does not match the column type.”
