Query Results that make a link to another query

[lewis33]

Thanks in advance for any direction you can offer on this bit of a problem. I posted it a while ago in the queries section but did not get any responses--I would like to do this project in Access initially but I will then transfer solution to a web-based, SQL Server application.

Basically, now, I have a query that brings in Name, SSN, address, phone and then also miscellaneous data such as certification status (Y/N) and also hospital affiliation names. These all show in the results although the SSN is hidden. Problem is that the miscellaneous data, especially the hospital affiliations, pumps up the number of records and makes it look like duplicate lines.

I'm wondering if I can create the query results so that the Name can become a link (or the SSN becomes the parameter) for the user to click on to bring up another data set to show all the miscellaneous data - that would eventually show on another .asp.

Any ideas obviously much welcomed. Thank you.

 

[dhookom]

A solution in an Access form will not migrate to asp very easily. All data entry and view should be done with forms so your postings in Querys and Reports are a bit out of place. You can set the Double-Click event of a control on a form to open another form. The new form that gets opened can be easily filtered to a specific SSN.

Duane
MS Access MVP

 

[lewis33]

Thanks very much- I really wanted to just make an example for now. The solution really doesn't have to be the same as the .asp's that will run eventually. I thought that the reports and forms have pretty much the same types of controls so some times I use them somewhat interchangeably but I'll follow up on doing this in a form with the double click event popping up a secondary form- thanks