I am trying to get an edit box figure to fill in the data from another field on a different layout. The problem I'm having is that the data sources are organized on a third layout that sorts enteries by date. I need the data to come from the data most recently submitted to the database. I've started a script but so far I haven't gotten it to work because its more complex than what I'm used to doing
What i need is Field 1 filled in with Data from the most recently added Field 2.
Any suggesting would be incredibly helpful. I am using filemaker 12/