maximum records

[pickelhaube]

Hello all,

yes, I am still new to FM10, and I get hooked on it. I have developed a collectors database, and like to make a demo available. BUT, I want to be able that a maximum of 10 records can be made. Is there a script ? or is this function within FM10 ?

I am a little stuck and I am thankful for any help.

cheers,

[Matthew F]

It seems that Filemaker lets you restrict privileges for the deletion of records via a calculation but not the creation of records.

It would be a bit quirky but you could create a script that triggers 'on record load' with something to the effect of:

Show all records

If (Get(FoundCount) > 10

Loop (Go to Record [Last])

Delete Record

Exit Loop if [Get(FoundCount) < 11]

End Loop

Show Custom Dialogue ["The maximum number of records in this demo is 10"

End if

[pickelhaube]

Yes, that script is working ok, when a button is pointing to it. BUT, the whole problem is that anyone can call/show the status toolbar and insert as many records as he wants.

If the status toolbar could be made - disable - or even hidden forever, then the problem would be so easy to solve.

cheers,

[IdealData]

As you have FM10 Advanced then you could investigate CUSTOM MENUS. This will let you remove the menu commands and you can either replace those menu items with your own scripted versions or just go with buttons.

[pickelhaube]

I got it. Well, at least it sort of works the way I want it.

Here it goes:

The above comments are great help, and yes, I did work with that.Now, my database starts with an - open - script, and there is where I put in a - show/hide status area. And while selecting - hide - I noticed a - lock - option on the left hand. THAT does the trick. I have a custom menu which does not have the records, etc in it. Going back into browser mode the status bar is still there but the option to show the toolbar is grayed out and is not accessible.

cheers,