I?m working with three tables: Use Profiles, Sites, and Reports.
- Sites is a parent to Reports
- User Profiles is a parent to Sites
The User Profiles table has a Quick Base username field that I use as the reference proxy in the User Profiles to Sites relationship.
I?ve created a lookup field, Sites ? Related User ID , in the Reports table that pulls the Related User ID from the Job Sites table lookup field Related User.
What I?d like to happen is that a user can be on a Report record, and click a button to open their profile in the Users Profile table in edit and additionally mark a checkbox field as true.
"<a href=" & $URL & ">" & $Words & "</a>"