FMP with MS-SQL views without any unique id
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?