Finding the first created record
I have a database with two tables the have a one to many relationship. There can be multiple children for each parent. The data is imported from an external source (excel). One of the field in the child is the date the record was created (not in FM but in the original source).
I have another table that does a calculation that is dependant on knowing the first creation date of a group of children (again this is a date that comes from the original source).
How do I create a field in my calculation table that populates with the child record with the earliest creation date?