However, what I want to be showing in the profile is the data displayed when you click on one of the collection items. The items are names of members. Is there a way to associate the member with the profile and be able to do this?
Your question isn’t completely clear, but if I’m understanding correctly, I think all you need is a single relation column in your Users table that matches the name (or ID, or whatever) with the same value in your second table. Then add a series of lookup columns to fetch the values that you need through that relation. And finally, use those lookup columns in your fields component.
The other thing you could do - which would be much simpler - is change your existing collection to a custom collection, filter it by user, then add your fields component directly.
If either of above isn’t the solution, then a redacted screen shot of the two tables (from the Glide Data Editor) would be helpful.