Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Database showing ID values not Text Labels

View all replies to this thread

Database showing ID values not Text Labels

Thread began 1/10/2010 2:28 pm by walt125013 | Last modified 1/11/2010 10:40 am by walt125013 | 1462 views | 3 replies

1/10/2010 2:28 pmwalt125013

Database showing ID values not Text Labels

This is probably a basic and simple question, but when I am using a seperate table to display values in my database I need it to show the text column not the column ID. For Instance:

I have a table of musical artists and then a seperate table with the artist Genres. The Genres table has a genreID column and a genre column, i.e. genreID = 1, genre = Pop/Rock

How do I get my database to show the Pop/Rock text in a web page instead of the number "1" when I am using the genre table as a relationship to populate a dynamic drop down?

I have a feeling this was poorly explained and way confusing...

Sorry! But this seems like it would be a common issue!

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.