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.
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.