Our Preferred 5 Star Hosting Provider - Award Wining FileMaker Pro Hosting
Results 1 to 4 of 4
  1. #1
    FREE Member
    Join Date
    Apr 2011
    Posts
    4
    Downloads
    0
    Uploads
    0

    2 Value Lists and If statement doesn't work

    Hi, I have a 2 drop-down lists working off the same value list and 2 If statements working off of the 2 drop-downs.

    PURPOSE: to get the employee name from his/her ID#
    1. one drop-down and if statement works -- for the main staff person. When I use the drop-down to find the Main Contact person's ID# his/her name appears in the Staff Name Field
    2. one drop-down and if statement doesn't work -- for the back up staff person
      This is set up in exactly the same manner as the Main Contact, but is not working
      • I've changed created a copy of the value list, changed the name of the list, and linked it back to the drop-down list
        • the list works, but no name appears in the Back-up Staff field, just my error message
    Can someone help?
    tks
    Amy
    Warning: This is an Old Thread
    This discussion is older than 420 days. information contained in it may no longer be current

  2. #2
    Senior Moderator - FMT Preferred Developer Consultant - New York - Worldwide AHunter3's Avatar
    Join Date
    Aug 2006
    Posts
    11,472
    Location
    New York and Nassau County, NY, USA
    FileMaker Version
    FM 9, FM 9 Server, FM 10, FM 11, FM 11 Server, FM 12, FM 12 Developer
    OS
    Windows & Mac
    Skill Level
    Developer
    Downloads
    0
    Uploads
    0

    Re: 2 Value Lists and If statement doesn't work

    I don't know why you're using any kind of IF statement either in a calculation field or in a script. What you need is a dropdown value list showing values from Employee ID also showing values from Employee Name. Pick the person and their ID drops in. Let's say you have a local field "MainStaffEmpID". You pick "John Smith" from the dropdown and John Smith's ID drops into MainStaffEmpID. Now you create a relationship between MainStaffEmpID to the Employees table, let's call that table occurrence "MainStaff". You can now put MainStaff::FullName on your layout.

    If I've misunderstood what you're tyring to do, (which is possible), it's because what you're trying to do is a lot more obvious to you than it is to someone reading your description; you need to go into more detail and remember that we don't already know your database structure.

  3. #3
    FREE Member
    Join Date
    Apr 2011
    Posts
    4
    Downloads
    0
    Uploads
    0

    Re: 2 Value Lists and If statement doesn't work

    THANK YOU IT WORKED!!!!
    Amy

  4. #4
    Senior Moderator - FMT Preferred Developer Consultant Arizona, NM, Texas, Southwest USA
    Join Date
    Mar 2006
    Posts
    2,761
    Location
    So. Arizona
    FileMaker Version
    FM 10 Developer, FM 11, FM 11 Server, FM 12 Server
    OS
    Windows & Mac
    Skill Level
    Developer
    Downloads
    0
    Uploads
    0

    Re: 2 Value Lists and If statement doesn't work

    Amy - there is a good explanation of some underlying and obscure (at least it was to me) characteristics of popup and drop down menus, and their behavior. AHunter was able to very effectively describe it in this FAQ post ....

    http://filemakertoday.com/com/showth...makertoday-FAQ

    Section 19.1 of the second post.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. HiliteMulti doesn't work
    By daanvdn in forum FileMaker Pro Custom Functions
    Replies: 6
    Last Post: 03-23-2009, 05:08 AM
  2. Copy script doesn't work in IWP
    By Suny in forum FM IWP - Web Companion and Web Publishing
    Replies: 12
    Last Post: 12-17-2008, 06:26 AM
  3. A Script that doesn'y work...
    By Diegushra in forum ScriptMaker and Scripting
    Replies: 17
    Last Post: 05-21-2008, 08:35 PM
  4. Logout on IWP doesn't work
    By MrEase in forum FM IWP - Web Companion and Web Publishing
    Replies: 4
    Last Post: 03-25-2005, 05:58 PM
  5. Email doesn't work
    By dvandam in forum FileMaker and E-mail
    Replies: 3
    Last Post: 02-28-2005, 02:47 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Welcome to the Original FileMaker Forum
With designated forums for almost every FileMaker topic...FileMaker Today is a free-to-join community where you can boost your FileMaker expertise, build better solutions and solve your technical challenges. If you're building FileMaker solutions, this is the place for you.
Follow FMT
We Are FMT
FMT is home of The World's leading FileMaker News Site, Worldwide Developer Directory, FileMaker Connect Community and so much more.