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]
