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
Entering data into one table that automatically appears on another
This topic has been closed for replies.
+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.
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.