Can't remove relationship??

Doug Blackwell

New Member
Joined
Apr 13, 2008
Messages
18
I'm wondering if someone can help me. I've created Access databases before, but my knowledge was a "know-only-what-I-need-to-know" basis. I'm now trying to re-learn it properly.

My problem is I created 2 tables both with phone number fields. I then created a relationship between the two tables linking the phone number fields. I then realized that one of the phone numbers was a number but the other was text. I deleted the relationship. But when I go to change the phone number from text to number it tells me I have to delete all relationships first. However, the relationship windows is empty.

I've tried googling and searching this forum, but so far no luck.

Thanks in advance.
 

SydneyGeek

MrExcel MVP
Joined
Aug 5, 2003
Messages
12,251
Go to Relationships view.
Click the Add Tables button and select all your tables.
Click OK and the tables will appear on the surface; any existing relationships will show up. You should then be able to delete the relationships.
When finished, close Relationships view and click Yes to save changes.

Denis
 

Doug Blackwell

New Member
Joined
Apr 13, 2008
Messages
18
Thanks! That did it!

I was afraid it would be something simple!! I guess I hadn't removed the relationships, just made them no longer visible.

Thanks again,
Doug.
 

Forum statistics

Threads
1,082,478
Messages
5,365,793
Members
400,854
Latest member
zenith_11

Some videos you may like

This Week's Hot Topics

Top