# Filter by user to account to table

**URL:** <https://www.five.org/t/filter-by-user-to-account-to-table/466>\
**Category:** How do I?\
**Tags:** how-to\
**Created:** [September 21, 2024, 4:20am UTC](https://www.five.org/t/filter-by-user-to-account-to-table/466 "2024-09-21T04:20:40Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![z3ror00](https://avatars.discourse-cdn.com/v4/letter/z/7c8e57/32.png) [@z3ror00](https://www.five.org/u/z3ror00)\
**Post date:** [September 21, 2024, 4:20am UTC](https://www.five.org/t/filter-by-user-to-account-to-table/466/1 "2024-09-21T04:20:40Z")

</div>

I have a list with an account table lookup. The account is related to a logged in user through a bridge table, IUserAccount. How do I filter a table for an account field they are connected to and hide the others?

 ![image](https://canada1.discourse-cdn.com/flex030/uploads/five/original/1X/88c37b2b797fd1f3172113e952222e51f5bd1a4f.png)

---

<div class="post-metadata">

**Author:** ![Dom\_Five.Co](https://yyz2.discourse-cdn.com/flex030/user_avatar/www.five.org/dom_five.co/32/38_2.png) [@Dom\_Five.Co](https://www.five.org/u/Dom_Five.Co)\
**Post date:** [September 21, 2024, 11:51pm UTC](https://www.five.org/t/filter-by-user-to-account-to-table/466/2 "2024-09-21T23:51:11Z")

</div>

Hi @z3ror00,

If I understand your question correctly, you’d like users to log in and only see information from their Account. In this scenario the bridge table between iUser and Account is actually redundant, because you can create a user role where the filtering happens based on your Account table.

To accomplish this, you can create a new user role in Setup \> Roles, and set the Account table as the security table.

Please refer to this blog post, in particular Step 8 on creating roles [Code-Along: Build & Launch a Business Partner Portal](https://five.co/code-along/code-along-build-launch-a-business-partner-portal/) for a step-by-step guide.

---

<div class="post-metadata">

**Author:** ![z3ror00](https://avatars.discourse-cdn.com/v4/letter/z/7c8e57/32.png) [@z3ror00](https://www.five.org/u/z3ror00)\
**Post date:** [September 22, 2024, 12:10am UTC](https://www.five.org/t/filter-by-user-to-account-to-table/466/3 "2024-09-22T00:10:39Z")

</div>

Do I need the bridge table for a user, such as myself, that needs access to a bunch of accounts at once?

---

<div class="post-metadata">

**Author:** ![Dom\_Five.Co](https://yyz2.discourse-cdn.com/flex030/user_avatar/www.five.org/dom_five.co/32/38_2.png) [@Dom\_Five.Co](https://www.five.org/u/Dom_Five.Co)\
**Post date:** [September 22, 2024, 1:27am UTC](https://www.five.org/t/filter-by-user-to-account-to-table/466/4 "2024-09-22T01:27:16Z")

</div>

No, you can give yourself the admin user role, which by default has access to everything.

---

<div class="post-metadata">

**Author:** ![z3ror00](https://avatars.discourse-cdn.com/v4/letter/z/7c8e57/32.png) [@z3ror00](https://www.five.org/u/z3ror00)\
**Post date:** [December 9, 2024, 3:30am UTC](https://www.five.org/t/filter-by-user-to-account-to-table/466/5 "2024-12-09T03:30:17Z")

</div>

I still have consultants that I want to give access to several accounts but not all of them or be an admin.

---

<div class="post-metadata">

**Author:** ![RileyAnderssen](https://avatars.discourse-cdn.com/v4/letter/r/5f8ce5/32.png) [@RileyAnderssen](https://www.five.org/u/RileyAnderssen)\
**Post date:** [December 9, 2024, 9:24pm UTC](https://www.five.org/t/filter-by-user-to-account-to-table/466/6 "2024-12-09T21:24:59Z")

</div>

Hello,

I made need a little more context as to what you are wanting. One method you could use is logging in as admin, and then assigning consultants to their respective accounts. Then when logging in as one of the consultants, they will only be able to see the accounts they have been assigned to.

Thanks,  
Riley.