If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
HELP.. me please
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 |
Thread Tools | |
Display Modes | |
|
|