[SOLVED] DW - How to show foreign key NAME in repeat region?

[banacan]

Hi All,

 

I have a product_list page where I want all of the details of each record to be visible so I can check that they were entered properly. Then I have EDIT and DELETE links for their intended use, all in a repeat region.

 

The problem is that 4 of the 10 fields in the table are foreign keys from other tables and their values were set by using drop-down lists. I can show the value of each field but the foreign keys are numeric and I want to show their word value from the other tables.

 

My repeat region is based on the listProducts recordset with the following SQL:

 

SELECT *

FROM products

ORDER BY products.mod_num

 

but that is what gets me the numeric value in those foreign keys. I have created separate recordsets for each of the foreign tables to select the record name:

 

SELECT divisions.div_name

FROM products, divisions

WHERE divisions.div_id = products.div_id

 

When I test the SQL it works just right, however I don't know how to include these recordsets in my repeat region behavior since the repeat region behavior only allows one recordset to be defined. I have tried creating one giant SQL to accomplish this but I can't figure out how to do that.

 

Am I going about this the wrong way? Should I just make separate tables and repeat regions for each of the foreign fields and align them? There must be a simpler way than that.

 

TIA

[banacan]

This was answered in the MySQL forum.

 

http://www.phpfreaks.com/forums/index.php/topic,178437.0.html