I would suggest using the Drop-Down List on the CC List field for the menu. This will stop folks from manually typing values. I would then have an Active Link that fires on menu choice to set another field with the corresponding mailing list. The Active Link would be set up to append to this field.
Dave -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Serouche Rahimpour Sent: Thursday, September 06, 2007 3:26 AM To: [email protected] Subject: Re: how to read the whole content of a drop-down menu Hi, sorry my concern lead everyone into confusion. So I'll try to explain my problem from scratch and in a simple way. I have a form let say A. In that form I have a character field called CC list. People can add logins in that field so each login corresponds to an email address. What I want to do is simply: do not allow people from putting in that field some logins. These later are mailing-lists. So I though I could put all these mailing-lists in a file and read from that file and compare with what is typed in. ... At this point I make it short because I tried different solutions either form myself or solutions given by you gentlemen of this list. ... Anyway, the problem I have at the end is my SET FIELD does not work if I use something like (("%" + $CC list) + "%") LIKE 'My Mailing-list' No matter if 'My Mailing-list' is stored as a file and red in a form through a menu. Or if 'My Mailing-list' is a form with for every mailing-list a record. .... Also no matter how I write the SET FIELD . i.e it also doesn't work if I write 'My Mailing-list' LIKE (("%" + $CC list) + "%") ... I hope I was clear enough. ... Any help/idea/suggestion will be very welcomed. ... I am about to try the solution given by Fred Grooms with 2 tempfields. ... Serouche Shellman, David wrote: > Serouche, > > I think your original question may have lead all of us down a path that > works but is becoming increasingly difficult. One of your recent > statements has made me rethink your original question. If I understand > correctly, you want folks to be able to populate a field from a menu but > you don't want them to be able to type in to the field. > > Have you tried setting the Display Type on the field to Drop-Down List? > This sets up the menu in a manner that prevents individuals from typing > directly in the field. > > Dave > > ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
