Linking 1 table field to 1 table

Hi! I need to do this:
I have 1 table with 1 linked field, when I click on this field I need to display an article containing another table showing results based on the @ID parameter.

Example:
This is the link of the linked field(Custom ID) of table A
mysite.com/index.php?option=com_content&...le&id=270&Itemid=110&idb=@ID

And I write this on the WHERE of table B:
WHERE idbonus = @idb

But the table B shows no results. How can I show the table B correctly?

I'm having a little trouble implementing this.

I have two tables set up. The first is set up as a table showing a list of individuals (and basic contact info). I'll call this Table A. The second is set up in card view, and is meant to show only one individual. We can call this table B. Table A is linked from a menu item, while Table B is included in a blank article.

Table B has nothing in the "WHERE" field.

Table A is set to use first column (Last Names) as a link. I've tried using the "Custom Link" field on Table A to create a link like this one: www.url_to_table_B?aso=exact&s_f=idbonus&data_search=$ID This will merely link to the whole list without filtering results at all (same A - Z listing in card view each time). Changing the link type to Article ID or Link ID causes a 404 error.

Should there be an actual field itself with this specific link information, rather than using the link area on the table settings? I think I might be misunderstanding how this part works.

Hi

I have two grid make on the same table but one with frontend tool jx for a listing and second with frontend card jx for a detail result.

In the result of the first i have a colunm with numbers of contrats. I want when the user click on this number he is redirected on the second grid with the result of number of contrat detail.

Sorry for my English

Ok use @ID instead of $ID. And it work !!!