I have a table called Diagnosis; it has fields for Diagnosis Code and Diagnosis Description. I'd like to use a check box to populate my Patient record (Patient Table.)

My reason for a check box is twofold:

1) It lets the doctor "study" all the available codes without need to scroll down a pop up list.

2) It will allow the doctor to easily choose multiple codes.

Since there are a lot of Diagnosis Codes

How about a new calculation field = DiagnosisCode & "-" & DiagnosisDescription

******* - that answer is so obvious - I feel like an idiot for even posting the quesstion!

Thank you very much sbg2 !

Well, I dont thinks its quite that obvious, I think most people would get the impression that "hey, I'm able to choose two fields for my list so there must be a property somewhere to simply add both to the current field Im selecting them in... right?".

If your DiagnosisCodes are unique and only have 1 description you can also relate the two tables by the DiagnosisCode and use the related field DiagnosisDescription on the layout where you are selecting the DiagnosisCode. The issue there however would be that if your description of a DiagnosisCode changed any record containg that code would show the new description.

I still think your original solution is the <EDIT> most <EDIT> eloquent - for its simplicity.

Thanks again,

Mark