Could you give me the HTML code for a hyperlink from a master table column that will link to a detail table in another article on the same page? I want the ID code to be the selector for the detail page. I know the FORMAT code in the master column should be something like:

<a href="index.php?option=com_content&view=article&selectedID={$columns:ID}">{$value}</a>

And then...what selection criteria should be used in the detail FILTER specifications? I again assume it would be something like

COLUMN NAME/ID EQUALS $_get['selectedID']

Hello,

For example if ID of the article which contains secondary table is 75, use the next code in for primary table:



Use the next "WHERE" clause for primary table to select specific records based "selectID" request variable:



PS: This approach is working for data from a database.

Regards,
ARI Soft

Thank you. This helps but I am using a CSV file as the source. Does this approach work with a CSV?

Unfortunately not. The extension doesn't support ability to use request variables for CSV filters.

Regards,
ARI Soft

Thank you. I still can't get the detail table to select the record when using a DB, not CSV. The site is www.2011efd.com/

The <a href in the format options for the 'index' column ( of the second MAIN table is:

<a href="index.php?option=com_content&view=article&id=51&SELECTEDID={$columns:index}">{$value}</a>

The call shows the correct SELECTEDID in the call to the detail table but the home page reloads and the main table disappears and a blank detail table displays announcing there is no data. I am using the following SQL call to load the detail page:

SELECT * FROM 'imageTesting' WHERE index = {$REQUEST:SELECTEDID}

NOTE: 'index' is the first column identifier ($columns:0) for both tables and I am using a DB.

Can you help me with this?

Could you provide temporary access to your J! backend by email so we could investigate the issue?

Regards,
ARI Soft