Hi all,

I need my script to copy the content of an text field and paste it into a value list. Is there any way to do this? The only option I have found is to have the script open the Define Value List box, but that is not going to do it for me.

Thanks,

Matt

Hi Matt,

It depends???

If it is an actual List in the Box there, you can use Edit or Other as part of the List functions in Format, However, if it is based on a Field, then of course the field would have to be populated with the entry, which means a new record if I'm reading this right.

This makes sense to you?

HTH

Lee

Unless there is a compelling reason I base all value lists on the fields they server. This makes adding to the value list as easy as adding a new record!

Hi Vaughan,

AFAIK, there isn't any particular weakness using one over the other, however, I ususally do that too. However, there are times when I use a field from a different file, or even a Fixed list. Really, it just all depends on the circumstances, I guess that's why FM gave us so some many different ways to go.

Lee

Thanks for the input guys.

I can't use the field as the source for the value list, there are many scripts that need to automatically update the value list. So my only option is to find a way to paste a current item directly into the value list.

I was hoping that there would be some simple syntax such as:

--Copy contents of field A

--Paste contents of field A into Value lIst X

maybe I need to use Applescript?

Thanks again.

[color:"blue"]

The best thing about basing the value list on a field is the ease that it can be updated. I have person phones me and says "I need a new value added to the list" and I say "Click in the field twice and type it in" and they think it's great! Power to the people.

Create another database just for the value list. One field on each record. make a new record and add a new item into the field. Base the value list on the field and call it from all the other files.