All Kind Of Errors

[shadowmaster]

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

 

[DCrake]

From what you have posted it is hard to test as the tables are empty thus no records are populated on the form. Plus you need to ensure that it will still load the parent table if there is no child data.

 

[shadowmaster]

thanks DCrake

appreciate ur response. if i load the tables with few data would it be possible to help me?
thanks again