i cant enter data in a table in one to one relationship in access.

[Guest]

i have problem entering data in a one to one related tables where one table
has data and i want to put data in the second one but it doesnt accept. could
some one help me please.

 

[Duane Hookom]

Why one-to-one? Are the tables related on primary keys? Are either of the
related fields an autonumber?

Do you have trouble entering in just one table or the other or both combined
in a query?

 

[John Vinson]

i have problem entering data in a one to one related tables where one table
has data and i want to put data in the second one but it doesnt accept. could
some one help me please.

If you're using a one to one relationship between TableA and TableB,
that relationship REQUIRES that a record exist in TableA before you
can add that value to TableB. That's what the relationship *means*.

If you want to be able to add records to TableA without requiring
anything in TableB, and also vice versa, then you cannot have an
enforced relationship.

One to one relationships are VERY rarely necessary - if you're not
familiar with the concepts of "Subclassing" or "Field level security"
then it may well be that you don't actually want a one to one. What
are these tables, and why do you feel a one to one relationship is
needed?

John W. Vinson[MVP]