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

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.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access


"shadowmaster" <(E-Mail Removed)> wrote in message
news:ED50CF4C-841F-456E-B2AD-(E-Mail Removed)...
> 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
>
>