Skip to main content
Question

Update one table, and automatically update another simultaneously


I have a table called "claims" (with cost) and the other "customer view" exact copy just without cost. I want to update the claims table, and for the information to go into the customer view automatically (minus cost) so that I am not doing double work. How can I make this happen? 
This topic has been closed for replies.

I suggest using only 1 table but have two forms and set the forms usage by Role.