May 7, 200421 yr I am trying to get the first 40 records of the field "id" into a new field "id_numbers". I bulit a script to do this with loop and set field for id_numbers but I do not know how to script or define a calculation that would take the first 40 records and put it into a new field then grab the next 40 records and put it into the next id_numbers record. I have been trying the omit multiple and then delete all records but how to get the 40 records into the one record is beyond my FMP level. Any help would be greatly appreciated. Thank you
Create an account or sign in to comment