Ok, So this one has me banging my head up against a wall. I am trying to create a site where a Customer can have multiple addresses and appointments. Customers, Addresses, and appointments are their own content types.

The Addresses & the Appointments are connected to the customers via the "Node Reference" Field Type via "Reference from URL"

I have set the proper Contextual Filters and Relationship in Views to be able to create a block to see the Addresses or Appointments of any linked node for the customer.

Where the problem is, is that I would like to have the Address FROM the Customer be a pickable item in the Appointment node. I feel that the relationship would be between the customer and the address but I don't know how to pull that information through to the appointment side.

Thoughts? Workarounds?