• Registered: 2019-07-15
  • Posts: 73

Topic: Limit number of records that a user can add

What is the best way to stop a user from adding a record if I have set a limit that the user can add into a table?

There will be other records in the table for other users so I need to count them for the current user and then give them a message and stop the add from happening.

Thanks

2 Reply by brian.zaballa (edited by brian.zaballa 2020-12-02 05:42:25)

  • From: Philippines
  • Registered: 2018-10-23
  • Posts: 417

Re: Limit number of records that a user can add

Here. I made a sample to give you an idea. That's one way I can think about. You can add a module or form to update the record limit of the user.

Post's attachments

Attachment icon alan_limit.zip 496.19 kb, 246 downloads since 2020-12-02 

brian
  • Registered: 2019-07-15
  • Posts: 73

Re: Limit number of records that a user can add

Brian,

Perfect, I understand how to make it work.

Thanks so much.

Love MVD