Hi Mark, Good to hear from you.
I agree, that would be nice.
This is a dictated business request. Imgine that these former teammates are going to be working for different companies and won't have access to the same data any longer.
The specific data for the work each team does will stay with them.
The link method I'm trying to preserve is to the table that lists all the team members, their managers, their desk-location, phone number etc. This person specific data is being split.
Since the date of the work they did is associated with them I'd like to maintain that association while splitting out the actual people across two completely different teams.
The key between the relationship is their Quick Base User ID, so that will remain the same.
When I make a new relationship to the new (split off) team's worker app/table, I end up with Related-team-member-1 and Related-team-member-2.
(1 links to the original app/table, 2 links to the new, split-off app/table).
As I'm spelling it out in more detail it is clear that it just can't work. I'll go for the wait until the end of a reporting period approach.
Thanks to you and Matthew for helping me process this!
Thanks,
David
