Access weird behaviour?

[speederpro]

The scenario:
I got a few tables in an access file. Their relationship
were all indeterminant. Then I found out that there are no
primary key on all the tables. I add a primary key to
table A and index the rest with no duplicates because they
should have a one-to-one relationships.

There are three forms: A, B and C. C is a subform of B,
and B is a subform of A. In Form A, there is a search
button.

The Problem:
While the tables' relationship are indeterminant, I can
use the search button to search a record and load the data
to B and C.

After I change the tables to a one-to-one relationship,
the data won't load to B and C.

Does anyone know how to fix this problem? Form B is
generated from Table A and Form C is generated from Table
B. Form A is only use for searching and loading data into
Form B and C.

 

[John Vinson]

The scenario:
I got a few tables in an access file. Their relationship
were all indeterminant. Then I found out that there are no
primary key on all the tables. I add a primary key to
table A and index the rest with no duplicates because they
should have a one-to-one relationships.

One to one relationships are QUITE UNCOMMON. Unless you're using
Subclassing (and know that you're using it, and why) I suspect you
don't actually want one to one.

There are three forms: A, B and C. C is a subform of B,
and B is a subform of A. In Form A, there is a search
button.

The Problem:
While the tables' relationship are indeterminant, I can
use the search button to search a record and load the data
to B and C.

After I change the tables to a one-to-one relationship,
the data won't load to B and C.

Does anyone know how to fix this problem? Form B is
generated from Table A and Form C is generated from Table
B. Form A is only use for searching and loading data into
Form B and C.

What are the Recordsources for the three forms? Are you attempting to
store data redundantly in the three tables? What are some typical
fields in these tables? I think the basic problem is in your table
structure, not the forms!