Limit Number Of Records?

[stealth162]

Is it possible to limit the number of records in a table. I have a sub-table in my database that I'd like to set a limit to 10 records. Is this possible?

[mr_vodka]

Why not just have it in your script for creating a new record that if there are already 10 records then prompt user that you can not add any new records.

[stealth162]

The problem with that unless I'm missunderstanding is that not everyone will use the script to create new records. What if they use the "new record" command built into filemaker? The script would be bypassed then wouldn't it?

[mr_vodka]

Well for me personally, I do not give my users access to those default menus. I try and let them use buttons as well as Custom Menus built for them (if you have developer/advanced).

What are you trying to use this table for anyway?

[stealth162]

I don't have developer or advanced. I was hoping there was a way to do it without that.

The table acts as a sort of grouping for records in the main table

ie; records in the main table that have a number that begin with 01 all group together with the 01 sub table and any info that is within it.

[mr_vodka]

Why do they needs access to create records in this table then? Cant this be controlled by an admin?

[stealth162]

There is other information that goes into this related table that the user inputs. Also, the number of records in this table is someimes less than 10.

[comment]

You don't need Developer/Advanced to restrict the creation of new records to scripted-only (the menu commands will be greyed out when you login as user).

[stealth162]

Well, I don't want to turn off access to that menu. It would slow the user down significantly if they couldn't create new records with a keyboard shortcut.

[comment]

Then I would look for a plugin solution. Although it's possible to disable the automatic commitment of records and set validation to prevent committing the 11th record, it's not something I would recommend.

[mr_vodka]

Or if you upgrade to FM8+ Advanced, you can create custom menus and still allow users to use shortcuts. It may be worth the investment.

[stealth162]

Looks like an upgrade is near in my future.