Have custom field requiring blank default value and need query to mimic actions of default Category field
In our Service Desk system, I want the user to see "Please select one..." in the Category field, but that can't be done with the default Category field. I've figured out how to create a custom field, label it Category, make it a Single Select list, and leave the default value blank. However, the query I use results in every possible category listing in my "Single Select" list with a "Top Level Category::Level 2 Category:Level 3 Category" format. The query I created is "select NAME as CATEGORY from HD_CATEGORY". I need my custom field to mimic the default Category field where it will bring up another Single Select list once the top level Category is chosen. Currently using K1000 version 5.5x. Has this been addressed in 6.x? If not, can someone provide me with the right query? Thanks !!