Is it possible to have two properties in the one cell?

[malhyp via AccessMonster.com]

Hi there, i have a text field in a table called "Category". In that cell I
have either the word "Trade" or "Retail".

This table and field is searched by a web site. Can I have the two text words
in the one field, so that when the search engine looks thorugh the database,
if you have both words it calls your details for both quires, Trade and
Retail. Text fields that have only one word, Eg: Trade, will not be found by
people seareching for Retail.

Something like this probably? (Trade), (Retail).

Mally.

 

[Nikos Yannacopoulos]

Mally,

Not a good way to do it. If there are only going to be these two
options, then you'd be better off using two yes/no fiels (one for Trade,
one for Retail) so in each record you could have either or both (or
none) checked, and you could query them much easier.
If, on the other hand, there is a longer list of possible values (even
changing over time), and for each record there might be any number of
them, then you have a classic one-to-many relationship, and need to add
another table to your design (tblCategoriesPerBusiness? i.e. one
business to many categories).

HTH,
Nikos