Skip to main content
Question

Creating multiple reference fields

  • November 29, 2017
  • 0 replies
  • 93 views

Hi, 

I have a table called "Team Members" which has a field called "Full Name"

I have a table called "Action Items" which has fields called "Owner" and "Assigned to".

Both "Owner" and "Assigned to" should take the "Full Name" from "Team Members"

It was easy to create just "Owner" by creating One-to-Many "Team Members->Action Items"

But now how do I create "Assigned to"? I tried to duplicate "Owner" and Rename it, but then they both take the same value. 
This topic has been closed for replies.

  • Registered
  • November 29, 2017
Can you explain the different functions Owner and Assigned to serve so I know how to recommend a fix?

  • Registered
  • November 30, 2017


Ah! I get it now. In that scenario, you would actually duplicate the relationship you have now for owners, but relabel the lookup field for team member to "Assigned To".

So the relationship is the same, but the function it serves will be different. Hope that makes sense.