@Blake
You can make a text field on the child join table of Team Members with a formula of
ToText([Team Member Userid]).
Then use a Combined Text Summary field to float up the Team member userids in text format up to the Team Record.
Ahh, but those are just words and not userids and you want a List User field to use in form rules or formulas .....
no problem, then make a List User Formula field on the Teams Record
var text value = ToText([Combined Text User (text format)]);
ToUserList(
ToUser(Trim(Part($value,1,";"))),
ToUser(Trim(Part($value,2,";"))),
ToUser(Trim(Part($value,3,";"))),
ToUser(Trim(Part($value,4,";"))),
ToUser(Trim(Part($value,5,";"))),
ToUser(Trim(Part($value,6,";"))),
ToUser(Trim(Part($value,7,";"))),
ToUser(Trim(Part($value,8,";"))),
ToUser(Trim(Part($value,9,";"))),
ToUser(Trim(Part($value,10,";"))),
ToUser(Trim(Part($value,11,";"))),
ToUser(Trim(Part($value,12,";"))),
ToUser(Trim(Part($value,13,";"))),
ToUser(Trim(Part($value,14,";"))),
ToUser(Trim(Part($value,15,";"))),
ToUser(Trim(Part($value,16,";"))),
ToUser(Trim(Part($value,17,";"))),
ToUser(Trim(Part($value,18,";"))),
ToUser(Trim(Part($value,19,";"))),
ToUser(Trim(Part($value,20,";"))))
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com------------------------------
Original Message:
Sent: 05-02-2022 15:47
From: Blake
Subject: Report Link Data
Hello!
I currently have two tables. One is Team Members and one is Team. I have linked all of the team members to their respective teams. I created a report link within the relationship and I am able to view a report of what team members are a part of each team. However, I am wanting to have a "Team Members" field within the Teams table. Is there a way to list out each team member on the Teams table without using a report link? I'd ideally like for the team members to be a user field within the teams table so that I can use this for setting up rules.
Thanks in advance!
------------------------------
Blake
------------------------------