Please help.

[scary1]

Please can anyone help. I have designed a patient database and I need to add on dates when the patient is seen by the medic.
A patient could be seen from once to 10000 times and I need to design something that would allow the medic to input the patients details to find the right patientand then simply put in the date they saw them and that gets stored so that the next time they see that patient they can again put in patient details to find the correct person and put in the new date but the new date does not overwrite the old date it is stored seperately. I don't want to have to set up a table with loads of date field as this will be tedious and also how will I ever know how many date fields to put in.
I am so stuck on this.
Any help would be gratefully received.

 

[Mile-O]

If you had a table with Patients with a PatientID you could then have a table that stores Visits where the PatientID is a field within visits


tblPatients

PatientID
Forename
MiddleName
Surname
OtherStuff

tblVisits
VisitID
PatientID
DateOfVisit
OtherStuff

then relate the PatientID to the VisitID with a one-to-many relationship

Should make filtering a lot easier...

 

[scary1]

Thanks very much.
Seems obvious now you have told me how!!