Value mapping table

ghamlb

Hello,

I have a custom object and field that I have a DQL based value assitance configuration. The query looks like this : select code, description from dm_dbo.prj_table ( prj_table contains 40,000 Code / Description)

The 'Query attribute providing data for display' is "description".

I want to set "code" and display 'description"

Any idea?

Ghaleb

lastnitescurry

Is this for single or repeating valued attribute? If single, 40,000 items in a drop down list is not practical.

If repeating, 40,000 items is going to be fairly painful

40,000 items is going to be troublesome and you probably will have to develop a custom locater with AJAX in it, to make life eaiser for end users.

DQL value assistance can only provide a "code" value, "description" will be ignored.

Solution options

@40,000 items I would go for custom locator, but dang that does not work with the new search controls in D6.0+ or is it D6.5+

Have not tried the following but technically it should work....

1) Figure out the DQL statement for updating the data dictionary "code/description" value assistance

2) Write a util to transform contents of "dm_dbo.prj_table" into Data Dictionary value assistance

3) Write util as method & job, if registered tables values need to change frequently