only one record

[Charity]

Okay, I have read and am making a Preferences table. How can I keep it to one record no matter what? I check unique but that does not. I thought maybe Get(RecordCount) = 1 but I thought I should ask how other do it first before I get myself in trouble.

[doughemi]

You just have to make sure that 1) your scripts never invoke a New Record/Request call to that table; 2) you use user permissions to only allow a very limited set of people the ability to create new records in that table, and 3) don't allow user access to the one and only layout that is based on that table. The last two are set in the privileges screens in File->Manage->Accounts and Privileges.

[Charity]

Hello Doug,

Thank you for helping me. Wow. Only a few sentences from you and it sure covered a lot of stuff to study!

Privileges seems fairly easy but I have no people or network yet so I can not test what I learn. I have made good notes. Custom menu is not intuitive but removing Duplicate, New, even Delete; heck, I see other things I want to remove as well. And I think I read that, if it is not on the custom menu then Ctrl-N will not work either. The two together plus letting only boss (that is not me) to layout all seems achievable.

I wish I could network me to me only with my computer and no server. I wish I knew what globals really did in multiple user relationships.

[doughemi]

I wouldn't go with custom menus just yet. The biggest problem with them is that they are universal to all users (and all tables unless you do a lot of menu sets for different layouts). Instead, use privilege sets to limit the access of different accounts. See http://www.filemaker...words.13.3.html and search for "filemaker privilege sets" in your favorite search engine.

You don't need to have a server as such to test a networked solution. Any machine running FMP can host up to 5 remote users. You just need a second copy of Filemaker and a LAN.

[comment]

Privileges seems fairly easy but I have no people or network yet so I can not test what I learn.

All you need to do is set up at least one another account assigned to a limited privilege set. Then login to that account to test.

You can also use IWP to access the same file as two different users at the same time, using only one computer and one copy of Filemaker.