Thanks so much for this, this is definitely a great start.
However, I keep getting "Field not found" errors and I'm not really sure what to do as it's not highlighting where things are going wrong. Let me describe the tables/layers I'm using a little more in detail with the field names.
The standalone table that has landings linked to each cable is named "LandingPlusCableTable" and has the following fields:
Cable_Landings_Export_City - This contains the name of the city where cables land.
Cable_Landings_Export_State_Province - The state or province where the city is located, shouldn't be relevant to this
Cable_Landings_Export_Country - The country where the city is located, shouldn't be relevant to this
All_Cables_Table_Export_OBJECTID - This field contains the CableID that is the unique identifier for each record in our submarine cable database.
All_Cables_Table_Export_SystemName - This field contains the name of the cable system that lands at the city
My Landing Points feature is structured as follows:
"STFLandings20180529_JOIN"
The only relevant field here should be the one that is pulled the City name: "STF_Cable_DBO_tblLanding_City" which has the alias "City"
Please let me know if you need additional information.