If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
recall of infor on a form
I have created two tables: table one has basic info lname, fname, grade,
student id number. Table two is an incident report form with fields: student id number, date ,grade , etc. I have a relationship from table one to to table two in a one to many relationship respectively. My user wishes to enter incidents on a form. So I created a form from table two and all works as planned. However my user would like to enter either a)student number or b) last name with out using a drop down list( long list of choices.) and then have it display both student number and last name then save incident to table 2? Also if you have multiple last name choices will it give you an option to select the appropriate one? |
#2
|
|||
|
|||
recall of infor on a form
I don't see the problem in using a drop-down to choose the student.
The user can type in characters to zero in on the student they want, no need to scroll through all the names. Your drop down to choose the student should be bound to the student id and you can display the id, last name and firstname in the dropdown. If 2 students have the same name, they can be distinguished by the id or some other column (maybe birthdate). -- Dorian "Give someone a fish and they eat for a day; teach someone to fish and they eat for a lifetime". "tonkaplayer" wrote: I have created two tables: table one has basic info lname, fname, grade, student id number. Table two is an incident report form with fields: student id number, date ,grade , etc. I have a relationship from table one to to table two in a one to many relationship respectively. My user wishes to enter incidents on a form. So I created a form from table two and all works as planned. However my user would like to enter either a)student number or b) last name with out using a drop down list( long list of choices.) and then have it display both student number and last name then save incident to table 2? Also if you have multiple last name choices will it give you an option to select the appropriate one? |
#3
|
|||
|
|||
recall of infor on a form
Thank you. I did use a drop down list and added the name fields to show as
well. He then can see the id number and a name to verify what he wants. I was just hoping to find another way also. How would I create a user input that would search both student id number and/or last names until a match was found? Also what would happen if two(ormore) people have the same last name? Will a select choice come up? "Dorian" wrote: I don't see the problem in using a drop-down to choose the student. The user can type in characters to zero in on the student they want, no need to scroll through all the names. Your drop down to choose the student should be bound to the student id and you can display the id, last name and firstname in the dropdown. If 2 students have the same name, they can be distinguished by the id or some other column (maybe birthdate). -- Dorian "Give someone a fish and they eat for a day; teach someone to fish and they eat for a lifetime". "tonkaplayer" wrote: I have created two tables: table one has basic info lname, fname, grade, student id number. Table two is an incident report form with fields: student id number, date ,grade , etc. I have a relationship from table one to to table two in a one to many relationship respectively. My user wishes to enter incidents on a form. So I created a form from table two and all works as planned. However my user would like to enter either a)student number or b) last name with out using a drop down list( long list of choices.) and then have it display both student number and last name then save incident to table 2? Also if you have multiple last name choices will it give you an option to select the appropriate one? |
Thread Tools | |
Display Modes | |
|
|