Restrict record view based on user

Restrict record view based on user

Hi!  I'm currently using the trial version of Zoho Creator as I assess the possibility of using it for our program management.  We have a group of consultants that meet with clients across the province, and I would like to be able to set up an App that houses all of our consultants information (including allowing them to submit expense reports, scheduling information etc.), and I want to have another App that has our client information, each client being assigned to a consultant.  

Is it possible to have our consultants be able to access the client App, but be able to access only the information for the clients that are assigned to them?  

I'm new to Zoho (one day into my trial), so the more detail you can provide would be helpful!  

Thanks!
Wanda