How do you attribute a polygon record with the field ID of the intersecting polygon of greatest coverage?
e.g. below area P00000392 intersects both Areas LE24 2SW and LE24 2RV, but I want P00000392 to be attributed with LE24 2SW (the largest area).
I've got as far as listing the area coverage by polygon, but I'm struggling to know what to do next. Any advice on this would be much appreciated.
I'm currently running a Pivot Table process as I type, but I'm not even sure this will do what I need. I'll let you know if I find a way through this.