I have NOT checked the "Do not store" box. In other words, the field is stored. Indexing is set to "All".
________________________________________________ Bruce Button Tel: 012-331-7072; Fax: 086-602-8247; Cell: 082-412-4972. PO Box 31442, Waverley, 0135, South Africa. Email: [EMAIL PROTECTED] -----Original Message----- From: FileMaker Pro Discussions [mailto:[EMAIL PROTECTED] On Behalf Of Christopher Kubica Sent: 12-December-2007 06:25 PM To: [email protected] Subject: Re: Value Lists based on calculated fields What storage options have you set up for the calc field? Sincerely, Chris Kubica President, Founder Application Architects, LLC Research Triangle Headquarters (P) 888-896-4608 (F) 888-896-4608 Certified FileMaker Developer FDA, Part 11, GxP, HIPAA and SOX Compliance Experts > From: Bruce Button <[EMAIL PROTECTED]> > Organization: Antipas Reformed Baptist Church > Reply-To: FileMaker Pro Discussions <[email protected]> > Date: Wed, 12 Dec 2007 18:22:07 +0200 > To: <[email protected]> > Subject: Re: Value Lists based on calculated fields > > The calc field is "Surname & ", " & Firstname". I have stored it and set > indexing to all. The value list works if I display the key and the calc > field, but not if I don't display the key. It seems to be a problem with > the indexing, because I also cannot sort on the calc field. > > Any help? > > Regards > > ________________________________________________ > Bruce Button > Tel: 012-331-7072; Fax: 086-602-8247; Cell: 082-412-4972. > PO Box 31442, Waverley, 0135, South Africa. > Email: [EMAIL PROTECTED] > > -----Original Message----- > From: FileMaker Pro Discussions [mailto:[EMAIL PROTECTED] > On Behalf Of Christopher Kubica > Sent: 12-December-2007 06:10 PM > To: [email protected] > Subject: Re: Value Lists based on calculated fields > > What is the definition of the calc field? > > Sincerely, > > Chris Kubica > > President, Founder > Application Architects, LLC > Research Triangle Headquarters > (P) 888-896-4608 > (F) 888-896-4608 > > Certified FileMaker Developer > > FDA, Part 11, GxP, HIPAA and SOX Compliance Experts > > > >> From: Bruce Button <[EMAIL PROTECTED]> >> Organization: Antipas Reformed Baptist Church >> Reply-To: FileMaker Pro Discussions <[email protected]> >> Date: Wed, 12 Dec 2007 17:57:50 +0200 >> To: <[email protected]> >> Subject: Value Lists based on calculated fields >> >> I am trying to make a value list based on a key field and a calculated >> field. I want the calculated field to display. The value list only >> displays the first record. (Filemaker Pro 8.5.) >> Can anyone help? >> >> Thanks >> ________________________________________________ >> Bruce Button >> Tel: 012-331-7072; Fax: 086-602-8247; Cell: 082-412-4972. >> PO Box 31442, Waverley, 0135, South Africa. >> Email: [EMAIL PROTECTED] >> > > __________ NOD32 2719 (20071212) Information __________ > > This message was checked by NOD32 antivirus system. > http://www.eset.com __________ NOD32 2719 (20071212) Information __________ This message was checked by NOD32 antivirus system. http://www.eset.com
