The simplest would be to put them in one Excel sheet. I did kind of manage it by adding a third file with a list of all locations, but this may not be possible for you. Equally I couldn't get the map background to work.
Book1.twbx.zip 150.4 KB
I'd advise using a custom SQL connection: something like this:
,[Nature of Crime]
,[Date of Occurrence]
,[Full Building Name]
,[NATURE OF FIRE]
FROM [mapper_campus].[dbo].[Campus_Features] AS a
JOIN [mapper_campus].[dbo].[Campus_Points] as b
LEFT JOIN [mapper_campus].[dbo].[Police Log]AS c
LEFT JOIN [mapper_campus].[dbo].[XREF] AS x
LEFT JOIN [mapper_campus].[dbo].[Fire] AS f
ON f.[Code]= a.[Code]
In this example, we join the shapefile to both Police and Fire incidents. Blog post here.