Join Table help

I'm not quite sure what you mean by "all the information from the member table" but for example, if you meant a list of the member names, then you can make a combined text  summary field on the assignments table (you do this on the left side of the relationship between Assignments and Members) to roll up all of the unique member names up to the assignment table.  

In my opinion, they will look kind of funny because they will appear in that bubble format that Quickbase uses for Combined  Text summary fields.  So I suggest making this text formula.

SearchAndReplace(ToText([Combined Text Member Name]), " ; ", "\n")

which will reformat that in to a vertical list.

Then look that up down to the Calls table.

If there are a few additional fields that you want rolled up, you would go to the members table and make a formula field that combines say two or three fields from that table into a string. And then roll that up to the Assignment table instead of  just the  name. 

If the phone number is unique, you van make it the key field of the Members table.  Then you can look up the Member info down to the Call.

As a safe first step, can you see what happens if you set the Phone Number in Members to be unique and click to check if its in fact unique.  Or make a summary report on Members sorted by the # of members based on Phone number and see if there is just one member per phone number.

Are you saying that you want a report so that for each Call, there is a record for each Member of that Assignment?  

This post makes clear to me why MarkShnier__You​ is a QrewLegend! I'm desperately trying to follow the logic, lol. I always did better solving a problem once I could see the app structure directly... 

I'm not sure if the existing relationship between Assignments and Calls is one Assignment can have many Calls, or if one Call can have Many Assignments. I'm assuming the former. So if a Member has many Assignments and Assignments can have many Calls, then it should be a simple thing to have Assignments lookup Member info from that relationship and if the Member info exists on the Assignments table it should be easy to then lookup Member info from the Assignments to the Calls. 

I think your best bet is to open a support ticket and grant the Tech Support Engineer access to your app so they can see exactly what we're working with and can then give you advice that is relevant to your specific app. 

The point that I have no confusion around is MarkShnier__You​'s advice to use a Bulk Upsert. He is spot on about the performance impact to the app. It's the kind of thing that will *probably* never be enough to slow the app down, but if you can build it better from the start, then why risk it?