# Record-level access control without redundant reference

**URL:** <https://community.dreamfactory.com/t/record-level-access-control-without-redundant-reference/3914>\
**Category:** Authentication & Security\
**Created:** [June 23, 2017, 11:29am UTC](https://community.dreamfactory.com/t/record-level-access-control-without-redundant-reference/3914 "2017-06-23T11:29:28Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![quangpld](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/quangpld/32/1021_2.png) [@quangpld](https://community.dreamfactory.com/u/quangpld)\
**Post date:** [June 23, 2017, 11:29am UTC](https://community.dreamfactory.com/t/record-level-access-control-without-redundant-reference/3914/1 "2017-06-23T11:29:28Z")

</div>

Hi DF team,

I followed this [documentation](https://wiki.dreamfactory.com/DreamFactory/Tutorials/Record-level_access_control) to control access at record level. However, to achieve the result I need to add the reference field to every tables that I need to gain access control. For example, let consider this use case:

- I have 2 tables: `orders` and `order_items` link to each other via a foreign key (let say an order\_id).
- In order to gain access control at `orders` table, I added a field owner\_id to the table and use that field to filter access control.
- In order to gain access control at `order_items` table, I also need to add owner\_id field.  
==\> But does DF support other way to achieve this goal (for example: linking the filter via foreign key) without adding redundant data to all tables?

Thanks in advance for your time and support.