I have this problem in my system, i need to register a patient to the system, patients reference_number is used to make a reservation in the hospital. problem i got is when a patient is registered to the system a reservation is made at the same time, i need to update two tables, patient table and reservation table, i have to take the reference_number from the patient table and enter it to the reservation table.reference number must be taken from the database, and new one should be one increment than the old one. how to do this guys? i'm confused about this. 
i'm develping the system using codeigniter,php and mysqlregards,Rangana
i'm develping the system using codeigniter,php and mysqlregards,Rangana