I am trying to create a DB for a pharmacy which is for repeat
prescriptions only. A patient may come with several items on a repeat
prescription. However, due to the quantity, the items may have
different repeat order dates. e.g. he may have Paracetamol to last for
3 months and Ventuline to last for 6 months and hence the pharmacy will
need to order them from the doctor on differnt dates.

Here are the tables that I think I need so far.

tblPatients: PaitentID,PatientName, Surname, Address, Tel,
[DoctorID]*slecetable from a list of Doctors
tblDoctors: DoctorID, DocName, Surname, SurgeryName, Address, Tel
tbleMedicine: MedicineID, MedName

Now the confusing bit:
I need to create a Form and a Table to select a patient (filling out
all his/ her details automatically) and to be able to add multiple
items selected from the medicine table with re-order dates for each
item.

I then need to be able to run a Query/ Report to give me a list of all
the patents that have items to be re-ordered for the current day. The
report should also include the items and the name of the surgery.

HELP ME... (

I hope I haven't confused you... cos I know I have confised myself! lol