The way to solve your problem is doing a union of tables: Location and PersonelAndLocation. To do the union you need to use common fields in both tables, for instance Latitude, Longitude, CODE, Country and Description. Field "Type" needs to be added to the resulting table.
Then you need to add a new field to differentiate those records from Localtion and PersonelAndLocation.
Having in one data source all this information will allows you to map it on the same map.
I hope this help,
your solution gives me everything on the same map, but causes problems with existing filters, since the Location table don't have data in the columns where I'm filtering.
The data in the Location table should be visible at all times, regardless of what I'm filtering on, i.e. "Travel Location".
Is there any other way of raching my goal?