all kinds 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
is there a way to attach sample of it?
help appreciated

thanks all

 

[Arvin Meyer [MVP]]

Before we can help, you'll need to describe what you are trying to do that
caused the error, what the error is, and what, if anything, that you've done
to resolve it.

 

[BruceM via AccessMonster.com]

I will just add to what Arvin wrote that three tables with the same primary
key call into question the design, especially if the same patient could be
listed in more than one table.