banacan Posted January 21, 2008 Share Posted January 21, 2008 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 Quote Link to comment https://forums.phpfreaks.com/topic/87108-solved-dw-how-to-show-foreign-key-name-in-repeat-region/ Share on other sites More sharing options...
banacan Posted February 1, 2008 Author Share Posted February 1, 2008 This was answered in the MySQL forum. http://www.phpfreaks.com/forums/index.php/topic,178437.0.html Quote Link to comment https://forums.phpfreaks.com/topic/87108-solved-dw-how-to-show-foreign-key-name-in-repeat-region/#findComment-455422 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.