Ask Your Question

How to quarry a list within a form field [closed]

asked 2013-10-22 23:13:52 +0200

alchemydragon gravatar image

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.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-05 11:55:00.390916

1 Answer

Sort by » oldest newest most voted

answered 2014-10-26 10:27:20 +0200

Alex Thurgood gravatar image

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.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2013-10-22 23:13:52 +0200

Seen: 82 times

Last updated: Oct 26 '14