Page 1 of 1

Block second add if one record

Posted: Fri Sep 13, 2024 12:39 pm
by crash

I’d like to see an option that prevents the user from adding a second record if there is already one record in the table.

This is useful for organizations with admins that register as a user and then add the details of their structure/group etc..

Currently we have to hide the add button etc.. this doesn’t always work so well in all the views and then the user sees the plus button and adds there structure a second time. Which is especially a problem if we have more than one user looking after the same structure.

Thanks


Re: Block second add if one record

Posted: Tue Sep 17, 2024 7:42 am
by MichaelG

You can simply add your codes in Row_Inserting to check if any record exists first.


Re: Block second add if one record

Posted: Thu Sep 19, 2024 5:31 am
by crash

I mean to hide the add buttons if a records exists.
It's common to see database users ask their members to add their info, but if the buttons keep showing the the users keep adding