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.