Relationship Issue

[Kevsim]

The database I am referring to is Access 2000 and populated.
I had 4 consecutive tables all linked together.
I added a table between table 1 and table 3, I went into Relationships and removed the relationship between table 1 and table 3.
I also had a query with both tables included, I have deleted this query.
I have redone the relationship which includes the new table 2, all tables are now linked with a 1 to many relationship.
When I view table 1 in datasheet view, it still shows the relationship between 1 and 3, how can I remove this relationship?
From table 1 my new relationship to table 2 is not recognised even when new data is inserted.

I would appreciate your advise.

kevsim

 

[dhookom]

I just turn off all subdatasheets in the table design view. You can manually set them to what you want. Possibly set them all to None.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Kevsim]

dhookom,
Thanks for the info, this fixes the problem, all OK now.

kevsim