CFMMaker

CFMMaker Discussion

Posted By :

Topic : Display a foreign key as another value

Time : 2004/6/10 21:41:19

Hello:

Is it possible to display a foreign key as a different related value in a list or view page? For instance... Let's say I have an Order table with a CustomerID field (foreign key from Customers table). However, I don't want to display the CustomerID in the list or view page of the Orders table, but instead want to display the Company Name from the Customers table.

Please advise. Thanks!

Webmaster (Reply to Webmaster)

Time :2004/6/11 04:53:46

To display the company name in customer table in the order list page, you can following these step:

1) select the CustomerID field in Order table
2) in The Edit Tag Panel (right bottom corner) choose "SELECT" as Edit tag.
3) checked "Use Table"
4) select "Customers" table in "Table Name" field.
5) select "CustomerID" in "Link Field" field.
6) select " Company Name" in "Display field #1"

And you can also refer to our tutorial "Selection List with Dynamic Option" in the help file, the first 2 steps are exactly the same.

Products

User Comments on ASPMaker

"Well done all, what ground breakers!!!!"
"You guys are the only people I know in sortware development who seem to get it right every time and actually take the time to listen to their audience requests."

"You don't know what you're missing!"
"I tested this product on one of my existing databases to see what it would produce; in less than 5 minutes I was purchasing a license for ASPMaker. If you code ASP pages from scratch, this will save you over 40 hours of work, easily! HIGHLY RECOMMENDED!!!"

"Essential Tool for REAL webmasters!"
"So easy to use, so affordable. Once I got it, I found more and more uses for it. I am not a programmer, yet I found ASPmaker to be extremely quick and easy to learn."

"Incredible"
"As a VB programmer, I would have to say that you guys have an incredible software. Good for you!!! To write that much code manually, would take days. I recommend this to anyone who is planning on writing code to interact with any ODBC Database. If you understand programming, you will appreciate it very much."