Move the pricing to a related table including a field to set the sales guy who creates the record. You can filter to get only each sales guys records (prices) in several ways (filtered portal, include global field with account name in the relation).
What I need to do is duplicate the 'Sales Team' layout and call it 'Sales Team Bill' and duplicate the 'Sale Price' field and name it 'Sale Price_Bill'. So the start up script will take Bill to his very own layout where no one can touch his custom sales prices. Bob continues to use the original 'Sales Team' layout and can work on the sale price independent from Bill.
This is a recipe for disaster. You do not ever want to set up a solution that requires a different layout for each user. It becomes a nightmare to maintain and update. You don't need different layouts anyway. You just need to, as arjen.evertse has recommended, set up different groups of pricing records for different users. You can then perform finds or use relationships (as well as Manage | Security ) to limit each user to their own pricing records.
I agree. Bill and Bob just need to get along.
Thanks for the valuable feedback.
I do realize when hosting a FileMaker solution on a server, users cannot edit the same record or field at the same time.
To be pedantic, record locking is not limited to files hosted with FMS, nor is it limited to shared files: a local single-user file can experience record locking if the same record is open and being edited in two windows.