My question is - how might I efficiently change these multiple choice text fields to be linked to a specific user without deleting said person fields
I don't really understand exactly what you're asking, you want to have a QB user named Field Tech? But it seems clear that part of your solution is a helper field that uses ToUser() function
https://login.quickbase.com/db/6ewwzuuj?a=dr&rid=178&rl=jkIs a double relationship recommended for this?
This is called a "many to many relationship". The foundational idea is that the 'relationship' is a third table - call it Actual Requests, let's say. So say you have PersonA, PersonB and PersonC and you have WR1, WR2 and WR3. If PersonA is assigned to WR2, you create a new Actual Request with those characteristics, and Actual Requests is a child to both parent tables.
There's TONS of education out there on this. You shouldn't have much trouble finding "Many to Many" tutorials that make this seem a lot more intuitive than it sounds like here.
