- 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
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