Starting a Data Base Over Again from Previous Records

Discussion created by fmpro_novice on Dec 7, 2018
Latest reply on Dec 8, 2018 by wintertj

My records have 52 fields on the layout - numbered 1 through 52.

At the end of 52 weeks, some of the fields will have data, some will not.

I need to be able to go through all the fields, find the last 3 fields that have data and store that data.

I will then delete all the data in all the fields - (so I can start over).

I then need to take the stored data and put them in fields 1, 2 and 3.


I have no idea where to begin this script. Does anyone have any ideas?