I am pulling tables out of Lotus Database to create reports.  The issue I am
having is that some tables have data for a specific record and some do not.  
For example, all of my locations have transaction data, however only a few of
them have any robbery data because they have not been robbed.  But when I
write a query to show all of my locations with transaction and robbery data,
I am limited to only the few that have robbery data.  I know that I need to
change my relationships to keep this from happening, but I am not sure
exactly how.  Any suggestions?  Thank you in advance for your help.