Data entry

[sssn]

I have a postion tbl where position desc is stored and the unique key is a position control number.Another tbl is the applicant tbl where all applicant info is stored. This has the control# field too to query how many applicants applied for a particular position. when the users enter the applicant data they dont want to enter the control# each time. How can I pull up the controk# from position tbl and then store the value in the app tbl?
Thanks,
Sheela.

 

[sssn]

Thanks, you are right I think I will change the database design.