link to another table

I would like to have multiple tables and link them together. They will have common columns, and pressing on a field, will point the user to another table giving more information for that field. Can you please help me out to do this. Maybe, if you can give me an example.

Thanks,
Constantine

I managed to link it ti another table , however it does not automatically execute the search once the table is loaded. How can we make it so the can be displayed with automatically being executed with the search parameters?

custom id: index.php/carrier-information?id=50$data_search=@ID

Displays all the table and the search button has to pressed afterwords. I want to automatically display without me pressing the search button.


Thanks,
Constantine

Not working...
I tried to also put s_f=datafield but does not give the results automatically. It puts in the value inside the search box but does not automatically execute. I tried with $ID instead but does not recognize the $ either.

I need some help or else this will not be useful for me.

Thanks,
Constantine