Dumb newbie database question (filemaker) linking fields with form input

Discussion in 'Mac Apps and Mac App Store' started by akm3, Apr 28, 2008.

  1. akm3 macrumors 68020

    Joined:
    Nov 15, 2007
    #1
    OK, this is so basic I'm embarassed I can't do it.

    Lets say I have two simple tables

    Table1: Client
    ClientID (primary key)
    Client First Name
    Client Last Name
    JudgeID (foreign key)

    Table2: Judge
    JudgeID (primary key)
    Judge First Name
    Judge Last Name


    In the "Client" input form, I want to be able to enter the client first name, client last name, and have them select the judge from a drop down menu containing the judges in the Judge table. I want the table to show the judges last name, first name.

    I can't figure out how to do this and I'm ashamed, please help me!

    I have set up the relationship in the management veiw, I have entered sample judges, I have set up the JudgeID (and clientID) to auto serial number. But I can't get that drop down to show the judges, even after playing around and setting the field to 'drop down', with a source of ...? JudgeID? Judge First name? I've tried all of them, but nothing appears in the drop down.
     
  2. akm3 thread starter macrumors 68020

    Joined:
    Nov 15, 2007
    #2
    Does anyone here use filemaker? I know this is really basic but I can't for the life of me figure out what I'm doing wrong.
     

Share This Page