Discussions

 View Only
  • 1.  User field as relationship reference field

    Posted 06-01-2021 14:58
    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
    ------------------------------


  • 2.  RE: User field as relationship reference field

    Posted 06-01-2021 16:01
    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
    ------------------------------