dropdown in access table --> pass info to Ultradev

[realik]

I have an access table which has drop down menus for several of the fields. When searching and displaying results in Ultradev, only a numerical value is displayed in place of the actual text. How do I get ultradev to display on the results page the text that was selected in the dropdown box in the access table instead of a numerical value assigned to the item?

Table - drop down box has text: Music / Video / Film
Results when searching for all records with Music:
UltraDev displays: '1' in place of 'Music':
Results:
1 / next field result / next field result / next field result

Thanks

 

[mlawson]

Hi there,

I use the same scenario for you if I am joining tables (in a relationship-type of situation), where I have numbers (normally autonumbers) relating to field descriptions. The way round this is to create an Access query and create a 'combined fields' field in the query builder.

If you have Access 2000 or 97, read the help file or visit

http://www.access-programmer.co.uk

for useful help.
Julian has a good site on how to create a parent/child dependant drop down menu in UD. His site is

http://buzzinet.ultradev.com

(or something like that)

Hope that helps.

Have fun

M