I have a field named Current_Call. I would like to be able to move the contents of that field into a repeating field Call_History within the same record. How does one determine the next empty cell in a repeating field in order to script the proper Set Field step? Thanks!

Edited January 14, 200620 yr by Guest

Hi

try this

SetRep.zip

I want to preface this by saying that I am not a fan of repeating fields.

Before you push your data into a repeating field, ask yourself whether you will want to use this data in some way in the future, because if you embed it in a repeating field now, you'll have a hard time getting it out again later. And what happens when you have a 30-repetition history field, and the 31st entry comes along?

Perhaps you could create (without too much trouble) a related table with all the information laid out in separate records. The "current" entry is simply the one with the latest date in it; the history is a portal showing all your entries...

David

Neither you need a repeating field to make what you wish...

Give a try to the attached file :(

History.zip