Help with Forms

[Lal-Bangalore]

Hi, My name is Prasad. I am a novice in MS Access. I use Access 2010. May I explain what n how I am stuck. I am a sales man in a book publishing house. We give sample copies of our books to various teaching faculties in different institutions. I am trying to maintain a database of the names of the professors whom I gave the books and which book. My revisit cycle to the same institution will be every 4 to 5 months. During our next visit also we would have given the same professors some new titles.

I have tried to create a access programme with the following tables.

1. Institution Table
2. Book title table
3. Sample books table (fields: Name of the professor, department, Designation, Phone number, Email ID, book sampled ( Title fetched from Book title table), Institution details (fetched from Institution table))

It worked well during my first visit. But now, after my second visit, I am finding the following problem:

I need to re-enter all the details of many professors whose details are already existing in the database (entries made thru a form), is there any way where I could fetch the details as I enter a professors name who already exists.

Looking forward for your response

Kind regards

Prasad.:banghead:

 

[JHB]

You need a table in which you register the professor.
Table fields:
(ID automunber), Name of the professor, Department, Designation, Phone number, Email ID

 

[Lal-Bangalore]

Thank you JHB. I highly appreciate.