i cannot seem to write a query that allows me to take information from a secondary table and write over some, but not all of the corresponding information on my Main table; is there a possible way to do this. I believe the problem lies in the cross reference of the data being inserted into the main table...anyone have any suggestions?