Automatically copy fields from two tables to another when New Register added
I hope you are not getting tired of me. The truth is that you are really helping me a lot.
I creating these account movement database, based on debits and credits.
Basically I have two tables where I insert the descript and value of credit or debit and when saving the record I would like these values to be copied automatically to a "central" table that register each movement on their respective date and then calculates initial and final value after the movement.
These Credit/Debit tables are related to the Movement table through the Credit IDcode and Debit IDcode.
I have no idea how to do this! Don't know if there are some scripts or commands to hrlp me do this. I'm kind of stuck here and really need the help of somehoe that knows what he/she is doing. :smileywink:
I'm glad if someone is so kind to start a conversation with to help me solve this puzzle.
Thank you very much.