Since you have given that one patient may have multiple prescription, so you have to do two tables: one is for patient and their detail contacts, date of checkup like thisand primary id shold be PatientID. Second one is for Prescription having PrescriptionID as primary key, other details about prescription and PatientID as foreign key. when you want to create a new prescription for a patient, just create a new record in Prescription table and put the PatientID over their. Just relate them by
Now to view multiple prescriptions for a related patient, just draw a portal over Patient layout based on table Prescription. It will show you all the prescriptions related to a particular patient.
Hope it will work correctly.
Thanks Kumar, I am going to give it a try and let you know, Sorry for the long delay in responding, had Internet issues.