I have a table called Routings_Master with a Related table Dresser_Details_Master through [Record ID]. Both tables have [Colour Code] & [Location] columns. What I want to achieve is if there is a Dresser record completed as part of the Routings record, I want the values from [Colour Code] & [Location] in Dresser_Detail_Master to be passed back into the corresponding fields on the Routings_Master record. From what I can understand though the function I am using for initial value (i.e. SELECT()) in [Colour Code] & [Location] in Routings_Master presumes the record exists already in the Dresser_Detail_Master table. Is it possible to pull values into a table from an associated table before all the records are saved?