Maintain Sort Order between different layouts
This is regarding FileMaker Pro 12.
I am new to FileMaker, switched over from Access. My level of expertise with databases is novice, so anyone who kindly provides an answer to the following, please give step by step simple instructions.
I have two layouts that I utilize in table view. Layout #1 sorted in ID (# field) ascending order. Layout #2 sorted by Last Name (text field).
After creating the sort in Layout #1, I then created the sort in Layout #2. When I returned to Layout #1 the ID field sort was gone and it was sorted exactly as Layout #2.
I am not running any scripts, that I know of. Is there something going on behind the scenes that could be causing this? And how would I check for that.
Thanks in advance for any assistance.