FileMaker Pro 3.0 Portals
Posted on 1998-09-18
Is there any way to use Data from a specific line (here from the last line) of a portal in a formula or for exporting the data?
Background to this question: In a database for software support I need a list of customers with their newest version.
I can't use Max(Installation::Version) because the version number is a text field, and using Max(...) FM will interpret the strings as numbers and this way version 2.01 will be treated as newer than 3.0 (it's the German version, we have a decimal comma, and so 2.01 is interpreted as 201)
I know that there is a script command to go to the last line of a portal, but having a specified field in the master database which is updated regularily with a script would take too much time.