Access weird behaviour?

  • Thread starter Thread starter speederpro
  • Start date Start date
S

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.
 
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.
Click to expand...

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.
Click to expand...

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!
 
Back
Top