Access access 2003 Driving me crazy

S

shadowmaster

Joined
May 11, 2010
Messages
1
Reaction score
0
Hello everyone,
i made small access 2003 application, it contains 6 tables 3 of them had a primary key which called "patientno", the other 3 contain the same field name but not as a primary key.
the main form i have is called "Patient info" it contains 3 sub forms (the ones with out the primary key).
now the problem is that i got all kind of errors 2501,2427 and a lot of other errors.
now can any one help and explain to me how to make the main form save and view data from all those 6 tables together? i tried query and every thing else but i keep facing problems
am attaching sample of it
help appreciated

thanks all

P.S press "shift key" while opening this so u can see all the forms and code
 

Attachments

  • General Practitioner Clinic.zip
    90.7 KB · Views: 76

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

all kinds of errors 1
Access Indeterminate relationship in many-to-many table (Windows 10, Access 2016) 5
Access Sub form opens before the main form in MS Access 0
Access ACCESS 2007 Calculated Primary Field 0
Same record/Primary key in multiple tables 0
Word Word merge from Access 2007 to Word 2007 brings over PK value and not text value. 0
Pop-up form that creates record that links 1:1 to main form 0
Access Access - Opening an related form 3

Top