Hello, I am using FileMaker Pro Developer 6 and I'm pretty new to it.

In my application, I want to allow the user to choose ONE among all currencies (US, CAN, UK etc) to work with.

I added a text box where the user can type his choice. The problem is, the user can add records to that table that is supposed to contain just one record, which is the chosen currency. Anyone knows how to deal with this?

Thanks a lot.

If you will control this with script, it will be easy. Remove all access to menu commands.

Alright. But can you give me a hint on how to do that? Thanks again...

I don't know what all is possible in developer.

Easy way is to do that in passwords security.

In the access privileges dialog, you can remove access to the menus so that the user cannot access the "New Record" menu item. Then you can make up a script to decide whether or not to create records.

You can also disallow creation of new records completely be unchecking the "Create Records" box. But if you do this, then you will have to create all records ahead of time, because the user won't even be able to run scripts that create records.