How to write a Script that duplicates a record in a different layout
So I'm really new at the Script writing part of all this. And it may sound kind of weird when I try to describe what I'm trying to do but please bear with me. I current have a table named "New Hire" and one named "Employee." What I'm trying to do is write a script that willtake the New Hire Record and create that record in the Employee table once the Start Date field is greater than the current date field. Is there any way I can do this?