AnsweredAssumed Answered

The selected columns contain some non-unique values and therefore cannot be used to uniquely...

Question asked by mplt on Sep 10, 2014
Latest reply on Sep 10, 2014 by mplt

Title

The selected columns contain some non-unique values and therefore cannot be used to uniquely identify each and every record in this table or view.

Post

I have created the following view in MS-SQL server.

create view FMP_ICLIENT_EXPORTATION as Select ICLIENT.* from ICLIENT LEFT JOIN LN.dbo.RM00101 ON ICLIENT.Nogp=LN.dbo.RM00101.CUSTNMBR where ((LN.dbo.RM00101.CUSTNMBR) Is Null) and stat='O' and autorise='1'

But can't use it in FMPa using ODBC from FMS : "The selected columns contain some non-unique values and therefore cannot be used to uniquely identify each and every record in this table or view."

Both tables have around 10,000 records and I can't find a way to do it in FMP in a fast way!

Can someone help?

Outcomes