I made a grid in admin for viewing all the applications received. I want to make a link in one column so when the admin clicks this link a new page will be opened. In this page I will pass the id and will fetch some data via collections. Further I have made front end form and all tables have collections. Please advice weather it is good idea to use collection queries to fetch data from db tables in the phtml file or there is some alternative to this. Remember this is not single query this contains some joins etc also.
Thanks in advance.