enter data into form from another table

[drshahriyar]

Dear users

i have 2 tables in my database. one table is used to book patients for a procedure and another table is for the procedure itself. when i am entering data for the procedure i have to reenter the name,age,sex and address of the patient which i have already taken and is stored in table 1. i need a code so that when i press a button the patient data in table 1 is pasted to the table 2. i don't want all the data in the booking table to be posted, only the data of the patient i want. thanks

 

[Uncle Gizmo]

If you copy the data over you will be making unnecessary duplications of the data, and also leave your self wide open to serious problems in the future.

If you look at your "patient table" each patient should have a unique identity. All you need do is copy this identity into your "procedure table" and you can then look up the patient details you require in the patient table with this linking value.