I'm using Microsoft SQL Server 7... trying to update the field [Division Head Name] in the table [Job Setup] with the value in [Name] from the table [PRPMSTR] where [Job Setup].[Division Head] = [PRPMSTR].[Employee Number]...<BR><BR>Any ideas as to how/if this can be done? I've been working on this for hours now and getting no where fast. It can be done in Access with some inner joins, but I can't get the syntax to work in Microsoft SQL.