Hi All,
First off apologies if this is located in the wrong section, new to this forum, but hopefully I can get some help here. Basically I am currently designing a database within Access 2010. The purpose of this database is going to be a medicine record system.
I have a table for patients (Patients), A table storing details of medication administered (MedicineAdmin) (This contains a field PatientID to link this to the patient table) and a table for details on the specific medication (MedicineDetails), which again is then linked to the MedicineAdmin table.
Within the MedicineDetails table there is a yes/no check box under the field heading "Finished" what I had proposed to do was that whenever this box is checked, either manually or via update query, that specific Medicine ID would no longer be eligible for use on a newly input MedicineAdmin record as it is finished.
I had two possible solutions to this problem I had thought of, please feel free to offer any advice/feedback or tell me if they are ludicrous:
- Append Query- using an append query move the specific finished medicine (Selected by inputting details into input box) to a table PreviousMedicines, seems simple enough, however would the link between the medicine and previous records be broken?
- Some form of code? I am not sure if this is even possible through access but it would be something like a "if value=true ..." where it cannot be used if the box is checked.
So this is my new dilemma and hopefully someone out there can help a newbie out.
Regards,
Daniel