use user input in layout to autofill a certain field in all records
i have a layout where the user can enter a date to view the records. i would like to make a script that would use the date they entered and fill the date field of all records in another table with the date just entered.
I have no idea how to get this done. Please help!!!!