Can anyone explain what the benefit of the different join types are when joining fields/tables in the relationships view in MS Access (I'm using 2010 but I guess this applies to earlier versions)? I can perfectly well understand why I might want a left outer join or an inner join when performing a query but I don't grasp what this does when I'm editing the relationships between tables themselves (i.e. not in a query). Clearly, 'enforce referential integrity' means I can't accidentally create orphan records (and query joins won't do this) but the applicability of join types outside queries mystifies me.