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!!!!
Check out Replace Field Contents.
You can use this option to put the same value (such as the contents of a date field or a variable) in the all the records of a found set.
Since this can modify data in a large number of records all at once, make a back up copy first.