First of all i want to salute all members!
I have made a simpe database to input medical exams.
As you Can see at the sample(mylab) One Patient has many exam orders and orders many exams, adde to the order_result table.Of course there are not only 19 exams but nearly 65.
Whats the problem. Many times users add the same exam twice and spend a lot of time to find the exams from the dropdown list. My knolege is limmited just above the basics.
So.. what i want to do. Create something like a form (probably from a query), from which the user can select exams and the selected exams will be added to the order_result table.
I ve tried the append query .. but i end up with headache and no result.
What i have in mind is like a form with all the exams (from table exams) with a selection box.
Those who are selected will add as records to order_result table. I hope i was clear ....
Thank you and have a nice day!!!!