What you are doing is like driving a car from the back seat. One should never manipulate data this way via tables - only forms and queries, and I see no mention of a form here. Even if it were possible (and I think what you want is not) I couldn't bring myself to figure it out for you and aid you in going down that slippery slope! Furthermore, it looks like what you want to do would be to repeat the storage of data you already have. Better you should build a form if you are already quite knowledgeable about database normalization, otherwise I strongly urge you to read up on the subject before you get yourself into a swamp, so to speak.
Last edited by Micron; 03-27-2016 at 10:39 PM.
Reason: clarifed the urge
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.