sorting records from a differnt table

[forbade]

Is there anyway to sort records in a different table, based on a relationship between tables?

 

 

I am having problems figuring this one out. Oh No!

What I am trying to do is, have a unique serial number created in one table and then that serial number get copied to a new record in a different table.

 

So far I have been able to create a lookup field, but it only lists the first instance of the related record, and i want to get the last generated serial, not the first one.

 

My Goal is to create a script that will sort the related records by date, then copy the last created serial number, and paste it into the new record in the related table. I dont know if filemaker is able to do anything this advanced, but any help or tips is greatly appreciated.

[Ender]

You might try an auto-enter calc instead of a lookup, using last(relationship::field).

[forbade]

thanks for your help