Restrict the access to record

[Bharathy]

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?

[Shannon_Bradley · Accepted solution]

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.

[TheTimeSavingCo]

+1 for trying out an Interface for this