Changing value list items into records

[michele]

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.

[Lee Smith]

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

[michele]

Thank you.