Updated connected Users field when new records is created

Hey Tada Community-

I am not sure if this is possible…

Would like to have a connection field in a User’s table (Associated Facilities) to be automatically updated when the logged in user creates a new Facility. Only the logged in user would have the “Associated Facilities” field be updated (no one else’s).

I have attempted to work with record rules, table rules, and Record Utility pipe but have not succeed.

Two Tables:

  1. Facilities
  2. Users

Connection from Users table to Facilities table for one to many titled as “Associated Facilities”

I welcome any thoughts or guidance.