Write to two tables?

[rc-alex]

Hello,
I am using web forms for use with Access and SharePoint 2010.

I need to write a form in which, when a user's new salary is entered, that information is stored as the user's current salary, but also put into a table as a salary change. (so that all salary changes can be viewed later).

I can't just use a query to show most recent change, because "last", "max", etc are not options in web queries. So I need to store the value submitted to both a field in the employee table, and also as another record in tbl_Salary_Changes.

Any insights?

Thanks
Alex

 

[pbaldy]

As mentioned on your other thread, this could probably be done with a data macro:

http://blogs.office.com/b/microsoft...ess-2010-data-macros-similar-to-triggers.aspx