One more try..... same question - adding 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.


Further explanation:
I want to add all the fields from a record to a new record in a subform with a combo box....can that be done.....
for example, I have a patient file that references a patient problem file as a subform with fields: Patient_num, Problem, Problem Desc, and Problem Goal. I am trying to use a quick entry form such as a combo or list box that references a problem list file that contains the fields Problem, Problem Desc, and Problem Goal. The best I have been able to do is to pull over only one field into the new form. I want to pull over all three field values. How do I get all three fields? I do not want to simply carry over the reference field.
Any suggestions? Thanks Ken

 

[kwtmd]

No

Well I appreciate your input.... but it is not the correct solution. I am very familiar with data base design and the avoidance of redundancy. However, this was not the question that I asked. Since the patient problems have thousands of variations, I only wanted to copy problem fields such that I might modify the input manually. The variations are subtle but significant. I was only using the problem list to save time as it would never be referred to again for that patient......

- Does the fact that this is the correct solution have any impact on you? In a properly designed database, data is NOT duplicated. Queries are used to join tables when data from multiple tables needs to be displayed together.

 

[Pauldohert]

Have you tried using muliple columns in the combo box?

 

[Pauldohert]

Have you tried using muliple columns in the combo box?

I read this question back and realise how daft it sounds - better would be - why won't muliple columns in the combo box work?

 

[kwtmd]

how do I do that?

thanks but how do I do that?

I read this question back and realise how daft it sounds - better would be - why won't muliple columns in the combo box work?

 

[Pauldohert]

1st set the rowsource of the combo box tothe data to be passed - so base it on a query from the problem list table (or use the wizard) including all the fields you want to copy to the new record


This way when the combo box is chosen all the data you want to pass is there in different columns of the combo box



When the combobox is updated pass the values in each column the way you have succefully passed one value - but this time refering to the correct column of the combo box.

to pass 3 values in a combo box -

On update event ---

txtfielddestination1 = combobox.column(0)
txtfielddestination2 = combobox.column(1)
txtfielddestination3 = combobox.column(2)

column(0) is actually the first column etc

Hope that helps

 

[kwtmd]

thanks

great....thanks....

1st set the rowsource of the combo box tothe data to be passed - so base it on a query from the problem list table (or use the wizard) including all the fields you want to copy to the new record


This way when the combo box is chosen all the data you want to pass is there in different columns of the combo box



When the combobox is updated pass the values in each column the way you have succefully passed one value - but this time refering to the correct column of the combo box.

to pass 3 values in a combo box -

On update event ---

txtfielddestination1 = combobox.column(0)
txtfielddestination2 = combobox.column(1)
txtfielddestination3 = combobox.column(2)

column(0) is actually the first column etc

Hope that helps