Jump to content
Salesforce and other SMB Solutions are coming soon. ×

sorting records from a differnt table


Recommended Posts

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.

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...

Important Information

Terms of Use