In a "wizard" generated data access page, if I have a pivotTable displaying the contents of my current database table, how do I make it so that clicking on any cell in the pivotTable will jump to the corresponding record for editing?

I've done this MANY times, but it was always on accident and I couldn't figure out how I did it. For this specific action, I've never written a single line of scripting. Sometimes the two just seem to link together by themselves, and other times they finally link after a few hours of toggling things on and off. I always get it in the end but I can never remember what makes it happen. Help anyone? Thanks a lot.