I have created a query in my DB. I want to add a hyperlink to each record produced in the query that will take me to that record in Form view. Right now, I can create a hyperlink that takes me to the form, but not one that takes me right to the same record.
A second thing I want to do is link groups of records in my main table so when I click on a hyperlink, it only brings up that group of records. Can this be done?