I have a database I want to do. The problem is that one of the fields in the form requires multiple entries. This is a database for herbs.The field is the Uses field. So basically for Cinnamon this field would have “Colds, Circulatory, Energy”. I want to be able to quarry this field using just one word like ‘Energy’. Is their a way to do this using Base? Thanks in advance.
So your “Uses” field is in its simplest format, a VARCHAR text field.
Your SQL query (or even the UI query builder) could use :
LIKE ‘%Energy%’
to find all records that contained the string “Energy”
A more normalised system would define a separate table for “Uses” with a unique identifier that could be referenced in your herb table as a foreign key, and then use a relation to link the two.