I have an unusual request. I would like to be able to create a combo box to allow users to first select from the contents of table a and if they do not find what they need in table a then display the contents of table b and if the are still unsuccessful in finding what they need, allow them to continue typing on. When finished typing what they want, save it into a table for future reports to be run.
Further detail:
To explain better what I am doing, I have two tables in which I want my users to be able to choose from. The first is a table of the most recently used physicians and the second is a list of all of the physicians. I want my user to be able to look in the most recently used list to see if the patient has used the physician recently. if it is then allow them to select it, if not than allow them to choose from the full list of physicians and if they still do not find the physician let them enter the new physician. And that is where I would want to save the new physician into a table so that in the future I can run a report of all of the phyicians that are not in the physician's list that may need to be added.
I hope that this makes sense.
Thank you,
Andrea
Further detail:
To explain better what I am doing, I have two tables in which I want my users to be able to choose from. The first is a table of the most recently used physicians and the second is a list of all of the physicians. I want my user to be able to look in the most recently used list to see if the patient has used the physician recently. if it is then allow them to select it, if not than allow them to choose from the full list of physicians and if they still do not find the physician let them enter the new physician. And that is where I would want to save the new physician into a table so that in the future I can run a report of all of the phyicians that are not in the physician's list that may need to be added.
I hope that this makes sense.
Thank you,
Andrea