Hi list. I've researched the past list entries with negative results. I want to provide sight impaired users with a field that contains a list of all fields on a form that have a defined Help Text. To do this, I obviously need some sort of menu to give those users the ability to select from. I know that you can build a Data Dictionary menu that displays the field labels on a form, and I can select the type, such as if I want character fields, or tables, etc. The problem there is that the menu displays all fields of the selected type, regardless if their hidden, visible, etc. I only want to select those that have help text. We have built a SQL menu that looks up the field where we have defined specific leading Help Text. For example, on any given form, all fields that I want to display in the menu have a Help Text leading value of "Help Text For". The SQL menu does a lookup on the fields table and selects the schemaid that matches the schema I am on, evaluates the fields related to that schemaid that have this leading help text and then presents me a list of those fields where the Help Text is prefixed in that manner. Problem partially solved. However, the trouble with that is, the menu pulls back the database name of the field, NOT the label name. As we know, database names are sometimes very cryptic, especially in the ITSM forms. Does anybody know of a way to build a menu that will: 1) At a minimum, only show me the fields where the Help Text has my prefix, but present me the label names instead of the database names? 2) Optimally, not only show me the fields where the Help Text has my prefix, and present me the label names instead of the database name but also limit that to fields that are specific to the VUI I am currently on? ARS 6.3 Patch 17 ITSM 5.5 SQL Server 2000 Microsoft Server 2003 Thanks in advance, Tim Powell
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
