1 Reply Latest reply on Sep 10, 2014 4:14 PM by mplt

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

    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?