Hi guys. I'm implementing script module adding to my customer addresses list their latitude, longitude and administrative area data. With lat and long- I don;t have any problem because it is in one table. But- administrative data not.
Geocoding google API give me back very inefficient xml table
So I guess I would need to join those tables and crosstable the result, but key field (%Key_address_component_3D78D9B402C68EA5) which define what "lone_name" is according to is not distinct.
I could make mapping table and load results few times but it would totally increase number of query and slow down whole app.
Any ideas? Thanks in advance