Hi,

I'd like to turn the value list items into records in a database.

So far I've succeeded in putting the items in a global and counting the number of items (with a patterncount function).

I want a script with a loop that would do the following:

-go to the first line in my global

-copy the data

-create a new record

-paste the copied value item

- go to the second line in my global

-....etc

until the last value list item in my global has been turned into a record.

I'm not sure what functions to use (how do I jump to the following line in my global)

Patterncount, Postition, Length???

Can anybody explain how to do it.

Thank you for reading and eventually answering this question.

Hi michele,

You are in luck, Bob Weaver made a tip file showing just how to do this in response to this thread: "Re: Extracting Values from Value Lists / Check Box'

Click here to go to the thread

HTH

Lee

Thank you.