I am wondering which is the best way to add a new field that is searchable.
I want to test a condition eg.
Is this progam 'available' or 'not available'.
I was going to add a 'YES/NO' field, but then thought how would the user go searching this?
The other way of doing it was having a field that would contain the full text ie:
'available'
'not-available'
AND making this field searchable with a level of '1'.
Which is the 'best way' of doing this? I thought if I could have a pre-defined search query as a link in my menu then the Yes/No field may be better - if this is possible.
Any thought's would be appreciated.
------------------
Clint
----------------------------------
www.AffiliatesDirectory.com
Proud Supporter of Links SQL
----------------------------------
I want to test a condition eg.
Is this progam 'available' or 'not available'.
I was going to add a 'YES/NO' field, but then thought how would the user go searching this?
The other way of doing it was having a field that would contain the full text ie:
'available'
'not-available'
AND making this field searchable with a level of '1'.
Which is the 'best way' of doing this? I thought if I could have a pre-defined search query as a link in my menu then the Yes/No field may be better - if this is possible.
Any thought's would be appreciated.
------------------
Clint
----------------------------------
www.AffiliatesDirectory.com
Proud Supporter of Links SQL
----------------------------------