Best practices question
Hi, I have a question about a problem I am having regarding my use of both FileMaker Pro and FileMaker Server simultaneously. I posted this on both the FM Pro forum and the FM Server forum because it involves both. Since you cannot use both prgrams on the same computer I have each on a separate computer (FM Server is set up all on one machine in the single machine configuration and FM Pro is installed on its own computer as well). My issue is that I am the database administrator so I am the sole person to make changes to the database EXCEPT for on one layout protion of the database where some users have the privilege sets allowing them to edit and change the layout and its records. I cannot make changes to the database through the Server computer since that is just a host computer with just the Server interface so I use the development machine that has FM Pro on it to make changes. However, when my other users access the database they are accessing the one that is being hosted on the Server computer (users access my database from remote locations and none use FM Pro software, I launch everything through Instant Web Publishing).
Currently, whenever I make changes to the database I save the file on the development computer using FM Pro but when the other users make changes to that particular layout and its records they are only changing the records/layout in the file being hosted by the Server computer. I am trying to figure out the best practice method for avoiding losing information by saving time/effort as well because I will either have a database with only my changes on it or only the users changes on it and I need both without having to physically replace the files back and forth between the two machines every time.
I was thinking of putting the layout that other users can configure in a separate file altogether and creating a link to that file rather than my current setup of having a link to the layout within the same file but I have never done this and it raises many other questions and concerns of compatibility/user friendliness. I am sure there is a proper way to manage changes and have congruity between the FM Pro and FM Server computers but I just don't know it yet. Please help! Thank you!