Thanks in advance for any direction you can offer on this bit of a problem. 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 affiliations. 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.
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 affiliations. 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.
