Thank you for your post.
Using FileMaker Pro 9, you can force Machine 1 to resort and put Record 6 on top, but Machine 2 will still display Record 6 at the bottom.
With the Auto-sort feature of FileMaker Pro 10, the information is automatically updated on all machines, so Machine 1 and Machine 2 will both see Record 6 at the top.
Thanks TSGAL - Yea, I was afraid of that. I think my whole earlier situation in trying to get machine #2 to update with new records after being given a find set was misinformation of some sort from the client. I talked to FileMaker Pro about it and apparently it is IMPOSSIBLE once given a Find Set to have a machine that does the find, show new records as they come in. That only works with the FIND ALL (^J) feature. If you do a FIND * (Wildcard) and still get everything (seems to be the same as a ^J/FIND ALL) you won't get new updates!
I begged them to add this functionality but they didn't seem to care :(
It would be really great if an update would add this functionality and quite honestly, I don't know how or why it isn't there already. Seems to be at least something that should be given the option to do. For instance, if you want to see only items that have today's date, you should be able (in list view of course), Find // in the date field and once it displays everything, any NEW item that comes in with todays date from another source SHOULD appear automatically on the screen. It doesn't right now.
My solution will be to have to upgrade my client to FMP10 and make a script that does the FIND ALL and sets autosort to sort their DATE field in reverse putting all new entries at the TOP of the screen, pushing everything down. Not what they wanted ideally, but it will work.