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
