Hi, I'm having trouble with a Distinct on a sharepoint list lookup field. I get only one record in the results (I've checked te collection).
Table Campos defines the type. Table Aplic-Campos joins those type with other fields from other tables.
The Distinct('Aplic-Campos', IDCampo) returns only one record: "Email". It should return three: "Email", "Nome" and "NIF".
I've tested with other similar tables (with lookup fields) and the result is the same.
The distinct works fine with a regular field.
Can you help me?
Thanks.
