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:
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:
Help with Forms
