I come more from a data analytics background, and am creating customer and company objects but all with numeric unique IDs. Obviously easier to join on IDs than on text.
For example, my customer object had customerID, customerName, companyID. Then company object has companyID and companyName. How do I "join" customer object (its companyID field) with the company object (its companyID field)? When I add a connection, it really doesn't let me select the field in each object that I want them to join/connect to (here, each companyID field). It's more some generic prompt about the two objects in general.