PrePopulating Fields in a Form

[nyrob609]

I have two tables - First table list all the medical drugs we use in our department. The second table will keep track of all the Medical drugs that were provided at the time of services per Patient. I created a form to enter the data per patient and how many drugs were used. I would like to make it easier by creating a look up box based on the First Table and when I find the drug I used. I want the data to populate in the second table corresponding field. This will avoid human error in spelling, wrong code etc...

Can any help me...thanks

 

[Galaxiom]

You should use a DrugID number as key field in your drug table.

The drugs should be added as values the second table using the key rather than the name. Your reports and forms display the name from the drug master table using a join between the patient record and the drug master table.

This way the names are only written once and there can be no mistake. If you do subsequently find a spelling mistake in the original entry it will be automatically fixed in the patient records when corrected. It also saves on the space reqired in the database.

Add the drugs to the patient record using a comboxbox set to hold the value of the key but display the name.

 

[nyrob609]

Thank you...it help and I also added subform that shows all the entries as I enter the recors using add new record command and also refreshes the subform and I am able to see the entries in subform.