AnsweredAssumed Answered

How to show only one one record instead of multiple?

Question asked by djmotor on Mar 14, 2018
Latest reply on Mar 15, 2018 by philmodjunk


Hello, i am starting to build a new solution base on the MSSQL database. It is connected via ODBC from Filemaker cloud to MSSQL server. So just to be clear MSSQL is where the data is located and i am using Filemaker to connect to it.

 

So my question is: I have a Student table and the records repeat itself multiple time based on versioning of the updated record. How can i filter them so in Filemaker i will see only one the highest version number?

 

Thank you in advance.

Outcomes