Forum Discussion

ChyanneEyde's avatar
ChyanneEyde
Qrew Trainee
4 years ago

User field as relationship reference field

Hello! I am trying to construct a relationship in which the key field and the reference field are both User fields. To demonstrate: In my parent table, Workers, the key field is Worker User Name and in my child table, Goals, I want the reference field to be another user field, named Worker Name. I have a very similar relationship between the same parent table, Workers, and another child table.

I just cannot seem to set up this intended relationship between Workers and Goals. Each time I do the system skips over the step to choose a reference field and automatically generates a "Related Worker" field. 

Any common reasons why a user field can't be used as a reference? Any particular tricks I should try?

------------------------------
Chyanne
------------------------------
  • I have not tested a user field, but have made relationships without issue using a Formula User field, so I suspect it should work. Any chance you are already using your child Worker User field in another relationship? If it's already being used, QB won't give it as an option - and if there are no options it skips that step.

    ------------------------------
    Mike Tamoush
    ------------------------------