Annoying relationships

[JB]

I've spent hours and hours fixing up the relationships between 6 tables.
I want to delete just one field from one table which actually isn't used as
a join field.
So it says I have to remove the relationship which I did. But it says still
says I have to remove relationships. Don't tell me I have to delete ALL
relationships???
Which seems crazy cpz I've spent hours working them out. I'll never
remember how to put them all back again!!!
Please help
J

 

[Jeff Boyce]

We're not there, so we can't see what it's telling you.

I would think you should be able to remove all relationships to the one
table with the field you are changing, but don't see why you'd need to
remove any others.

 

[Febup]

I was a total dodo.
I was removing the wrong relationship. doh.

 

[Ed Robichaud]

For help in remembering your table relationships, from the Relationship
window menu you can print the graphic layout as a report. When deleting
relationships, you may need to close/save the new relationship setup,
close/save the involved tables, and lastly run Compact & Repair.
-Ed

 

[Febup]

.. Thank you

For help in remembering your table relationships, from the Relationship
window menu you can print the graphic layout as a report. When deleting
relationships, you may need to close/save the new relationship setup,
close/save the involved tables, and lastly run Compact & Repair.
-Ed