AnsweredAssumed Answered

FMP with MS-SQL views without any unique id

Question asked by mplt on Jun 27, 2014

Title

FMP with MS-SQL views without any unique id

Post

     I'm trying to link to a MS-SQL Views that has no unique id. So FMP won't let me connect to it (see image).

     I created this View table base on one table that also do not have unique ID. I have tried to use ROW_NUMBER() without any luck.

     Anyone could help me here?

     Thank you.

error.png

Outcomes