Originally Posted by moke123
Heres one example on how to exclude an item from the list if its already been selected.
Moke123 i ve tried a lot but ... i couldnt much it to my db... my knolege is limmited... Thank you anyway, i really think this is the way. The only thing that needs to be changed is to take the order id.. from somewhere and not from a dropadown list, so the selected exams will be the records of Patient order exams. Like the link you have posted, i ve changed the patient with Patient_order to match with my db and the other table was edapy_Exams, the join table for me is Patient_order_exams. ... and then i lost it!!!
I really need somebodys help with this part.. if you like.
Because i dont know how to handle macros, i cept the names you gave. When you try to add without an id sows message,which is correct. What i couldnt do is to change combo2 so it could be linked with the open patient order (patientid for your example)
You can see the relationships and understand what i mean.
Anyway thank you very much for the idea, you are great!!