Thanks John.
I have a database of coach information including: coach first name, coach last name, coach cell #, coach email, school address, school city, etc.
I have a separate database with recruit information and their coaches information. What I'd like to do when I add a new record is when I type in the high school name, the coach information automatically is entered.
I hope this helps. I appreciate any guidance.
Thanks!