Thank you for your post.
Yes, FileMaker Pro will allow you to work on the same database at the same time. If one person is editing one record, the others are locked out from editing that record, but they can edit other records. When the customer finishes editing the record, the data is saved and others can then edit the record.
Each user would need their own copy of FileMaker Pro on their machine.
FileMaker Pro does have a scripting language that will allow you to automate tasks. You can also set up the forms exactly the way you want. I would suggest you download a trial copy of FileMaker Pro from our web site and try it for yourself. Have another user download it and try it out sharing the same file.
If you need additional information, please contact me.
Thank you very much for the swift reply. I'm trying out FileMaker Pro as we speek, and honestly it seems like the perfect solution for us.