The first thing to do is learn how to manage the properties of the various table fields and in particular:
- Size (if the type is Text, don't always leave 255 set (this is to limit data entry to what is strictly necessary)
- Required (if set to yes, it does not allow saving the record if the requested data has not been entered)
- Allow zero length (must be set to No if data is always required)
- Indexed (set to "Yes (no duplicates allowed)" when you want a field value not to be entered more than once and therefore unique
- Index Management
Control, beyond the ID field, to avoid duplication of records because before moving on to creating the forms and then any reports, it is necessary to have a definitive efficient database structure.
In the attachment you will find a version where you can filter by Category even if you have not selected any Entity and a cleaner code.