Quick data entry of multiple fields

[kwtmd]

I am writing what I thought was a simple Patient form to enter new problems for a patient. A patient may have multiple problems. I want to add problems quickly from a pre-defined list of problems. I have a Patient File which is linked to a Patient Problem file. I also have a Problem List file that lists problems as well as other fields that further define the problem. I have made a form with Patient file as the parent and Patient Problem file as the child. I have been able to use a combo box to quickly add one field of the Problem List record. However, I want to add multiple fields from the Problem List by some quick means to the Patient Problem file but have been unable to figure out how to do this......

I was given the suggestion to use the Multiselect list box, but I do not want multiple records, but rather multiple fields from a given record.

Any suggestions? Thanks Ken

 

[The_Doc_Man]

I was given the suggestion to use the Multiselect list box, but I do not want multiple records, but rather multiple fields from a given record.

Well,... actually you DO want multiple records. It is called NORMALIZATION. You are currently thinking along the lines of spreadsheets, which is OK, but Access is not Excel. Access doesn't do spreadsheets. Not very well, anyway.

You have a one-to-many case in reality (one patient, many problems); why should you not have a one-to-many table relationship to represent it?

Convenience, by the way, is the wrong answer. Because the INCONVENIENCE of adding one more problem code becomes a nightmare when your record size heads towards 2048 bytes because of all the yes/no fields you are trying to store.