How to or is it wise.
I have a list of table 1 when clicked I want to show -> the list -> and the clicked item.

Question:
I do this by making twice the connection to table 1. the second one is then the limited one. Is this the correct way or should I do it in an other way?

I have never tried this, but you might want to put a hidden layer on your page that will show the results of the item clicked. You will have to make two recordsets on the page. One to show the list and one to show the results from the clicked link.

HTH