Automatic Fields?

[mwiley2011]

So, I have two sets of data: Recipients and Applicants. Applicants is a large pool of students applying for a scholarship, and Applicants is those who have received a scholarship.
Right now, I have them in two tables, and I want to create a form "Award Scholarships" where the user can type in the name of the person and select the scholarship from a drop down list (lookup field to Scholarships table) and it will add that person to the Recipeint Table. I run into a problem with primary keys, because I don't want the user to have to enter the Student ID (Primary key on both applicants and recipients table) for each student because they would have to look it up. The Applicant table, however has all of that data in it already.


Is there a way to type in Student FName and LName and have it automatically fill in the Student ID?

Or maybe there's a different way I can approach this?

I hope I provided enough information on this..

Thanks!

[alansidman]

Here is a tutorial on custom filters on a form. This should get you started.

Alan

http://www.datapigtechnologies.com/f...tomfilter.html

[mwiley2011]

I don't have speakers at work so I'll let you know if I get it figured out next week. Thanks!

[alansidman]

Just a thought, ipod headphones can be plugged into the speaker outlet if you have them and had not thought of it.

Alan

[mwiley2011]

I don't have them with me Thought of that too.