I have a table created to hold all my client data. The data is all entered in via form. When a new record is created (new client added) I also need to create an opening transaction balance on a separate table. So what is the best way to...
1) Identify that a new record has been create
2) Subsequently a new opening transaction record needs to be created?
I'm having a hard time getting my head wrapped around a process flow to accomplish this. Any thoughts or insights would be greatly appreciated. I am open to VBA or macro builder.