Need Suggestions to Eliminate Unplanned Table Behavior

[Terry]

I have 3 tables. One of which I get unplanned, unexplained behavior when
double-clicking the table to open it in datasheet view. When I double click
Table 2 (described below), I get a prompt to enter Table 1's Primary Key. If
I select Cancel, the table opens. If I put in a valid or invalid Table 1
primary key, it opens. What is driving this behavior?

Table 1 has a primary key field and and a Type field.
Table 2 has a primary key field and a Name field, plus a field for a foreign
key (number data type) for the Table 1.Type field.
There is a relationhip between Table 1.primary key (parent) and Table
2.foreign key field (child). Referential integrity is enforced.
Table 3 has a number field to be used as a foreign key for the Table 2
primary key.
There is a relationhip between Table 2.primary key (parent) and Table
3.foreign key field (child). Referential integrity is enforced.
Any help is greatly appreciated,
TerryoMSN

 

[Dorian]

Do you have any lookup columns in table 2 referring to table 1?
You coukld also try deleting the relationships between 1 and 2 one at a time
to see which one might cause the issue.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

 

[Jerry Whittle]

Make a backup then do a compact and repair.

 

[Terry]

I think I found what the problem was. I originally, before using the
relationships tool, had lookups from the Lookup Wizard on the table. Using
the Relationships tool, I deleted those lookup relationships when I added the
key to key relationships. Or I deleted what I could see in the Relationships
tool. I looked back in the Lookup tab in Table Design for Table 1 and found
the Table/Query and Query entry left from the Lookup Wizard. After deleting
those two values, the table is now behaving itself. Thanks for the hint.
Terry

 

[Jeff Boyce]

Terry

This may be reading too much into your post ...

If you are trying to use the data in Access, but trying to "open [a table]
in datasheet view", you are making it harder on yourself.

Access tables store data, Access forms (and reports) display data. Using
forms gives you MUCH more control...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.