Entering data into one table that automatically appears on another


I am trying to create a database where when i enter a payment for a customer on one for it automatically puts that payment onto another form. How do i do it.

Thank you

To automatically create a record in another table then you will probably need to use Zapier or a similar service.

However, are you certain you need the second table? Why can this data not remain stored in the first table? In general, duplication of records across tables is unnecessary and problems llike this can be solved by adjusting your database structure.

And, it creates other issues sustaining authoritative data. For example, what if there’s an error and you correct it in the first table. Now you have a crisis of data truth because it’s very difficult to instrument partial duplicative processes.

Perhaps you really need another “view”. Same data, just rendered or presented slightly differently.

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.