Browsed byTag: search options

If you have ever wanted to search a large amount of records either by Name or Category, or other fields, there is a somewhat simple solution which uses an auto-calculated text field, which is used as a foreign key multi-value list and global fields to perform a relationship match. You only need 1 table to perform this type of operation. 1. Define the fields Let us say we have a table of companies which has the following fields: id name category…