Hi guys,
I have been search for hours but I am having no luck. I am an Excel guy and I do not know much about Access or SQL.
Anyway - I have created a Microsoft 2013 web app, to manage sales (like a CRM tool). It works well, but when I created a query to show me all the 'open leads' the name of the lead (which is the key that links multiple tables together, is no hyperlinked as it usually is.
This means that when I open the query in the web app, I see the data I have asked to see in the datasheet view but the usual hyperlinked name is not available for me to link on.
I know I need to click on the lightning bolt, then press 'On click', select 'OpenPopup' as the expression, select the table I want to view... but its the 'Where' bit I have no idea about.
If I just do the 'View' bit, it shows me the list view of all of my leads, which is almost there - I just need it to open up on the exact lead I have clicked on in the query...
Any help would be greatly appreciated.
Kind regards,
Will
I have been search for hours but I am having no luck. I am an Excel guy and I do not know much about Access or SQL.
Anyway - I have created a Microsoft 2013 web app, to manage sales (like a CRM tool). It works well, but when I created a query to show me all the 'open leads' the name of the lead (which is the key that links multiple tables together, is no hyperlinked as it usually is.
This means that when I open the query in the web app, I see the data I have asked to see in the datasheet view but the usual hyperlinked name is not available for me to link on.
I know I need to click on the lightning bolt, then press 'On click', select 'OpenPopup' as the expression, select the table I want to view... but its the 'Where' bit I have no idea about.
If I just do the 'View' bit, it shows me the list view of all of my leads, which is almost there - I just need it to open up on the exact lead I have clicked on in the query...
Any help would be greatly appreciated.
Kind regards,
Will