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

    Nov 15, 2007
    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

    Nov 15, 2007
    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