202.65.131.44/CMS/ this is what i got and this was exactly what i wanted but after clicking ont he code no page is opening..

SELECT
 *
FROM
 t_prospectivecustmaster
WHERE
 CustomerCode = {$REQUEST:CustomerCode}

this is the sql query i fired on the 2nd table
is it correct?

If you send customer code in "CustomerCode" request variable then the query is correct.

Set "Columns settings -> ID" parameter to CustomerCode and "Column settings -> Format" parameter to the following value in main table:

<a href="index.php?option=com_content&view=article&id=20&CustomerCode={$value}">{$value}</a>

Regards,
ARI Soft

Hi,

I have been working on some site upgrades and had a question. I searched through the forum looking for previous answers and came across this thread, which is similar to what I am doing, so I decided to post my question here.

Again, I am doing exactly what is explained here in this thread. I have an ARIDataTables module displaying a table of data. In the first column I have a link using the same href method to load another table. I am passing the ID for the desired record row as the $value. It works great.

My question is, can I pass other $REQUEST variables through this same "href" link URL to the second table? The $REQUEST variables are already available to the first page via its' the URL. I want them also available to the second page. For example, one of the variables I have in the page URL is "vNewCity". I want this to also be passed through the href to the second page. Any ideas?

Thanks.

Ken

Hello,

It is possible to use {$REQUEST:vNewCity} variable in "Columns settings -> Format" parameter.

Regards,
ARI Soft

Thank you very much. That makes sense, I knew there had to be a way. I kick myself for not trying that before contacting you.