Search results

Thansk so much Kraj, I've now created a new PK ClientID, should I conitnue to create it in all the other tables for linking purposes. My PatientId has meaning to users. P'se I want a fully fledge DB so that when I get to doing reports I have little trouble. Thaks in advance, Samia

So do I change in all the tables where I have Patient ID to AutoNumber? Yes, it is visits to a clinic.

Hello Everybody, I thank you for this great resource. It's helped me a great deal on my project. Now, my problem is: I want to have a fully fledged DB system with reports and all. I know DB development is a process and that I'll keep adding more tables. However, for now I need to get this DB...

Mile-O-Phile, I appreciate so much. I'll look at this and try to follow. Just wish I could be able to do the forms like you did them. Once again, thank you for your time. Samia

OK, I finally found the many-to-many example. However, it just confused me the more. I've reduced my tables to three now like this; tblPatients PatientID - PK FirstName LastName tblvisits VisitID - PK Date Outcome tblComp CompID - PK Complaint Please help me.

Oh God! Thanks so much. It's exhilarating. I just started learning this 2 days ago. Samia

Hello Everybody, Please advise. I have created a main form with a subform for data entry. After data entry into the main form it continues to the subform for data entry. Am I doing the right thing. What I want is for the demographich data to be entered in tblPatient (main form) and tblHistory...

Mile-O-Phile, thanks again, I don't seem to find it. Thanks Samia

OK, I get it. How bout if I code the complaints; say persistent headache = 1 and just enter the number 1. Will this solve the problem. I greatly appreciate all your help. Am new to Access and I want to do a good DB. Samia

Thank you all for the fast response. CollinEssex, DateAttend is the date of registration (first). And the reason I've this is I didn't want to change to form so much. I want the screen to look exactly like the card. Mile-O-Phile, that was just an example. I've provision for up to five...

Hello Guys, I appreciate all that you're doing and thank you for your time. I would like to transfer pateint information from cards to access. I've so far managed to come up with the following tables. Please correct me if am wrong. tblPatient PatientID - PK RegistrationNo (patient no on the...