Adding data to a field on a table via a query (not append)

[plems2]

I have a table where I capture several fields. Most of the fields are populated by a form, but I have two fields (columns) where a query needs to run to pull data from other tables. I do not know how to populate the fields and save the data on the table

ID	Description (from form)	Month (from form)	Sales (from query)	Units (from query)
1	Promotion a	January	How do I save data here from other query	How do I save data here from other query
2	Promotion b	March	How do I save data here from other query	How do I save data here from other query
3	Promotion c	May	How do I save data here from other query	How do I save data here from other query

[orange]

Tell us about the "other tables". We can only guess what they might be.

[plems2]

The other tables are sales table brought in via ODBC connection. My team enters the promotion description and other information that are important like dates into a form that populates a master table. I use the information in the master table to run a query against tables via OBDC connection. I just do not know how to add the results from the query back to the master table with and have it match up with the corresponding record. I hope this make sense.