Recent content by LukeMills2010

The reason I have it setup like this is because asset data is imported from two sources. The secondary source is considered to contain assets that are not registered in the primary asset source and I wan't to distinquish these. Is that a valid reason not to follow the rules of normalisation.

Hi, Access 2003 I have two different tables which contain assets with the same primary key ('Serial Number') and these fields are linked via a one-to-one relationship (No Ref Integrity). I am trying to figure out if their is a way to query one of these tables for records that don't have a...