Entering data into one table that automatically appears on another

[boston_barker]

Hello

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

[David_Skinner]

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.

[Bill_French]

David_Skinner:

duplication of records across tables is unnecessary

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.

[Bill_French]

boston_barker:

when i enter a payment for a customer on one for it automatically puts that payment onto another form.

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