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.