Can I automatically update a value list?

[Mabou]

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

[Lee Smith]

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

[Vaughan]

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!

[Lee Smith]

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

[Mabou]

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"]

[Vaughan]

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.

[Vaughan]

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.