Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.
I'm also attaching a jpg that shows the relationships.
UPDATE tblPositionSymbol INNER JOIN (tblShrtName INNER JOIN (Newposition INNER JOIN tblPosition ON Newposition.ID = tblPosition.PositionID) ON tblShrtName.ID = tblPosition.tblShrtName_ID) ON tblPositionSymbol.ID = tblPosition.tblPositionSymbol_ID SET tblPosition.quantity = [newposition].[quantity], tblPosition.cost = [newposition].[cost], tblPosition.[$gain/loss] = [newposition].[$gain/loss], tblPosition.[mkt value] = [newposition].[mkt value], tblPositionSymbol.[as of date] = [newposition].[as of date];
Join the community of 500,000 technology professionals and ask your questions.