I have two tables Properties list and Budget. In the Properties table, I have a user field that we can assign the property manager to that particular property and that manager is only able to view and edit the Budget(budget table) details belonging to the property.
But in budget table has many records of multiple properties detail. But that particular property manager should be able to view and edit Budget details belonging to that property. The rest of the details can be visible or hidden but should not be editable.
Is that possible?
Solved
Restrict the access to record
Best answer by Shannon_Bradley
I'm sure there are a lot of solutions, but the easiest might be using Interfaces. It is so simple to set up so that only the needed fields on the needed records are accessible by the assigned person. You can also streamline the look so that there is less "training" for new people. They just get an access page that looks like any other web form. There are a couple of videos that go over how Interfaces work if you haven't used them yet.
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
