markdo

Thanks for help with script... Works beautifully. Regarding... I just like a clean database with clean reports. Is there another way to keep things orderly?

Where can I find a general discussion of the "commit" function? What it does. How to implement it. Etc. Thanks

Sorry about the confusion regarding "or" ... I was referring to using the script in 2 separate instances... so I wanted a script that was flexible enough to allow either instance. The script you provided works great. I wrote this database in 1997, without any prior knowledge of FMP, and continually update its functions. I am not a professional, and understand only the surface of what I am working with. I am the only user... It works for me... but it is not as refined as I would like. I would very much like to add the "commit" function to ID entry. It definitely sounds like a better practice. Can you show me how you would write that script? Thanks Mark

Each record I create has a unique ID. When I create an new record that ID automatically increases by increments of 1. When I create a record in error, and delete the errant record, I need to reset the next ID so it retains a linear progression. I have created a simple script that allows me to reset the unique ID of the next record Go to Record/Request/Page [Last] Set Next Serial Value [Visit::Statement No.; Max (Visit::Statement No.) + 1] The above script works, except for one thing: I want the reset ID to read: "00000X" or "M0000X". In each case the reset value increases to the next value, as required, however the FULL ID is ignored. For example "00005" when reset becomes "5". "M00005" when reset becomes "5". How do I modify the above script to maintain the original ID configuration: "00000X" or M0000X" Thanks

Thank you all for your input. I am very grateful for your generosity.. Mark

I want to create an online database that will find a physician (from an unposted list) based upon city and state. or better yet all physicians within 100 miles of a specified zip code... Any suggestions? It should be a fairly simple solution. Thanks... Mark