Yes, you must have a portal on the right if you want a menu on the left. What I have done to accomplish this is use a TAB panel, with the number of tabs being the number of menu options. Set up each with a button behind your menu description that runs a script with a parameter that indicates which menu option. Then your script can handle the details. Here is a screen shot of an example. I used a colored box to hide the tabs. Cheers, Mark
Excellent mark_b and thank you. That definitely helps to extend the functionality. So how do you prevent a new record from being created within the layout?
Re: "Q. How do I prevent new records from being created within the layout"
A couple of ways come to mind:
1. Base this layout on a system table and use access privileges to remove users' ability to create records in this layout.
2. Control the setup with scripts so that (1) only one record exists in that table, and (2) cancels any attempt to make another record.
The easiest way (what Keywords said) is to use Filemakers security. I set up an Account Name of "Entry" (or what ever you want to call it) and set it up with with a copy of "Data Entry Only" privilege set, then edit the privilege set to not allow creation or deletion of records from the table your layout is based on. I hope that helps.
Use Custom Menus to disable, remove, or reprogram the New Record commands.
Requires FileMaker Advanced to edit the menus. If you change the command behavior, it will also change the behavior of the Icon in the status area (if that's visible).
Thank you keywords. Just few questions.How would I wr
What is a 'system table'? Is that different from a normal table?
How would I go about writing a script that cancels any attempt to make a new record?
1. Most developers use a separate table to hold things like global values that the want to use within a solution. The usual technique is to store such values in standard fields, and then use a script which runs each time the solution is opened to load them into matching global fields. This table is variously called a systems table, a utility table, a globals table or whatever. The easiest way to prevent records being added is to use FM security settings so that regular users cannot create records in this table. The Custom Menus method suggested by Stephen is another.
2. A script to cancel any attempt to create a record could detect a found count > 1, alert the user that they will cause problems if they proceed, and then delete the newly created record. The easiest way to activate such a script would be using Custom menus as suggested by Stephen, to reprogram the New Record command.
Thank you again. All makes sense now.
Excellent and thank you Stephen. FM Advanced is on my wishlist.