I have 2 Sharepoint Lists:
Entidade_ID | Nome 1 | ABC 2 | DEF
Diario_ID | Entidade_FK 1 | 2 2 | 1 3 | 2
I want to add a lookup column to
Diario to get the Nome of
In SharePoint, this is what I'm doing:
Get information from "Entidades" and return NomeCurto (the name).
But where does the Foreign Key go!?
This operation adds a column to Entidades but an empty one, because the foreign key isn't anywhere!
I hope this makes sense and someone can help, I've read the whole documentation, but it isn't there either.
I tried also the following setting:
But this also returns an empty column.
I think it is because the target list has other foreign keys which now contain little red icons...