You can add a separate form/table to store the various combinations of category and problem description and another for category and resolution. You could load it via .csv from an export of your data, possibly refined via MS Excel pivot table & a little massaging. After this, build a simple search menu for each field to display the values.
Mike White
Office: 813-978-2192
E-mail: [EMAIL PROTECTED]
"Shrestha, Manjari
R." To: [email protected]
<MANJARI.R.SHRESTH cc:
[EMAIL PROTECTED]> Subject: Changing the
way a field works
Sent by: "Action
Request System
discussion
list(ARSList)"
<[EMAIL PROTECTED]
RG>
10/25/2007 06:56
Please respond to
arslist
**
Hello List,
I have been given a task to automate the problem description and resolution
field so that once the category is selected, these fields should come up
with selection choices. My dilemma is, these fields right now is a text
field. How can I convert this into a selection field without changing the
data that is already in the database. Should I be using active links but
how can I have the text field show up all the choices? Please advise.
Thanks in advance.
Manjari R. Shrestha
__20060125_______________________This posting was submitted with HTML in
it___ __20060125_______________________This posting was submitted with HTML
in it___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
<<inline: graycol.gif>>
<<inline: ecblank.gif>>
<<inline: pic03264.gif>>
