Please help if you can.

I am trying to bring in data from a different database that had a long list in a drop down menu. I am trying to bring this list into a table that has a record for every entry in the drop down list. I don't want to have to do this manually. I've got the field to display the list from the other file, and when I create a new record the field is auto selected and all I have to do is hit the down key to select the entry, but I can't seem to automate this. I'm guessing I can use the get value list function to pull up the list, but I can't get my head around how to automatically create a new record, and select the next value in that list and on and on. Please help.

Thanks.

Steve

The way I'd do that is using the ValueListItems function, e.g.

/* This script makes a new record

   for every item of a value list */



Set Variable( $items ; ValueListItems("myFile";"myList") )

Loop

  Set Variable( $i ; $i+1 )

  Exit Loop If( $i > ValueCount( $items ) )

  New Record

  Set Field ( item ; GetValue( $items ; $i ) )

End Loop

thank you very much. I'll give it a try... I was on the right road, but didn't have the details.

Cheers.