data macro for access web app

[alissb]

Hi. I am somewhat new to Access web apps and stumped on making a data macro work when it is related to a query.
I am trying to update the value of a field in a table based on a value in a query.
Here is the scenario:

• The table has many records with the same order number.
• The query determines the status of an order number with a calculation based on multiple tables.
• I would like change the status field in the table to the value of the status field in the query with the same order number.

Any help would be appreciated how this could be done in an Access web app.