Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Display foreign key name vs ID

Display foreign key name vs ID

Thread began 6/11/2010 8:58 am by tlshoaff392246 | Last modified 6/15/2010 8:58 pm by Miguel | 1841 views | 4 replies |

6/11/2010 8:58 am | #1 tlshoaff392246

Display foreign key name vs ID

I need to display the a foreign key name, however when I alter the query my results disappear. It seems as though DataAssist only pulls from tables. Is there a solution so that I can display the category name and not the id on my results page?

6/11/2010 10:58 am | #2 Jimmy Wu

To start off, I have to warn you that making modifications to the code makes this not a supported feature.

If you could describe your database structure, the query that is applied by DataAssist and the query you modified, I can try to point you in the right direction.

6/11/2010 11:04 am | #3 tlshoaff392246

DB Structure

There are 2 tables: content and category. Category has 2 fields: catID and catName. In the content table there are many fields but it has a fk called cCategory. What's interesting to me is that I can have a dynamic dropdown on the insert and update pages that shows the name and not the id but on the results page it shows the id only. Seems like I should be able to choose the label name.

6/15/2010 5:04 pm | #4 Jimmy Wu

and what does the query look like before and after you modify it?

6/15/2010 8:58 pm | #5 Miguel

Sounds to me that you need to do some joins on your query

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.