yhchen
Registered User.
- Local time
- Today, 09:45
- Joined
- Jul 6, 2008
- Messages
- 63
Hello experts….I have created a log system recording the usage of student services which is currently working just fine but I am looking at making some improvements….
The log form is called “Log” which writes data to a query called “Log_Data” (contained two tables: “Log_Table_Enquiry_Data” and “Ticketing Data”), there is a section which requires user to enter “Student_Number” and “Student_Name”.
As we are getting quite a few returning students, I thought I would like a function when users enter Student Number, the system will:
1. Search the existing data and fill the field “Student_Name” if there is a matched data (and actually write both fields to the system)
2. If there is no matched data, it will accept data entered and write into the system
I am not sure if this is achievable but any expert views will be very much appreciated…
Many thanks in advance for any possible help that you can offer...
The log form is called “Log” which writes data to a query called “Log_Data” (contained two tables: “Log_Table_Enquiry_Data” and “Ticketing Data”), there is a section which requires user to enter “Student_Number” and “Student_Name”.
As we are getting quite a few returning students, I thought I would like a function when users enter Student Number, the system will:
1. Search the existing data and fill the field “Student_Name” if there is a matched data (and actually write both fields to the system)
2. If there is no matched data, it will accept data entered and write into the system
I am not sure if this is achievable but any expert views will be very much appreciated…
Many thanks in advance for any possible help that you can offer...