Removing an existing relationship leaves behind the foreign key

N

Nefarus

Hi,

Here's another problem I'm struggling with.

After creating and linking a relationship between two tables, I now
find that I no longer need that relationship and want to delete it.

Deleting it is no problem. I can select the relationsip and delete it,
but trying to delete the relationship without removing the underlying
data structure is is posing to be difficult.

Visio does ask if I want to "remove the selected item from the
underlying model"? I don't. If I say "No", it removes the relationship
and doesn't remove the feild, which is what I want, but it also leaves
behind the FK assignment, which is no longer relevant. How do I remove
this FK assignment?

Again, any help in this would be much appreciated.

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

issues on table with relationship to self 2
VBA Doorway to Database Properties 1
Implementing a many-to-many relationship 4
relationship questions 3
Composite-key Primary Keys ==>> Foreign Keys 5
How to Delete a relationship from the underlying model 0
Outlook 2000 leaves messages in outbox when sent 3
Which Foreign Key in which table? 16

Top