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
+14To 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.
David_Skinner wrote:
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.
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.