"Show Description Field" Error

[genericjanedoe]

I have a database search form on my main database that requires a search of records using data from other joined databases.

These sub-databases are joined to the main via their ID numbers (the only way I could get them to work together). When I want to enter a new record in a data entry form, the drop down list takes information from the ID field, but shows the field description as per the option "show the description field" available through the drop down list, and this seems to work.

However, when I do a seach using the database search form, The description appears in the drop down list, but when a selection is made the field then shows the ID number instead, even though the "show description field" option is still checked.

Any ideas how I can get the form to show the description field?

 

[paulbent]

That's how it's supposed to work given that you have created the list from the id field.

I would put both the id and desc fields on a "find form" and make them dropdown lists created from their own fields with no description field used for either list. Then you can search by id and desc. If the form is also used for data entry then make the desc field read-only

Paul Bent
Northwind IT Systems

http://www.northwindit.co.uk

 

[genericjanedoe]

I thought that if you checked the "show description field" box, the description field showed in the box, not the ID number? It certainly works if I am an in "browse" mode. The problem seems to occur if I use the "find" button.

I've tried putting both ID and Description fields on a form, but both of them show the ID number. The description field is also "read only" - but this makes no difference. The problem is exacerbated because when I add ID and description fields from a second database (and attempt to filter it from the first database), not only does an ID number show up in both fields, but none of the entries are filtered either.

 

[paulbent]

The list description only displays during selection of an item. Once the item is selected, the actual list value, not the description is entered in the field.

Paul Bent
Northwind IT Systems

http://www.northwindit.co.uk

 

[genericjanedoe]

Many thanks, I've found a work around; by designing a "found data" box separate to the drop down lists. Once I've asked it to search, it brings up the required description there.