Go Back   Access World Forums > Microsoft Access Discussion > Tables

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 10-14-2008, 07:59 AM   #1
mg55345
Registered User
 
Join Date: Sep 2007
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
mg55345 is on a distinguished road
How to Delete Fields with Relationships

Hi,

When trying to delete an old field I don't need anymore, I get this error message:

"You can't delete the field 'FieldName'

It is part of one or more relationships.

If you want to delete this field, first delete its relationships in the Relationships window."


The problem is, when I look at teh relationships window there is no sign of a relationship here. Where should I be looking to delete this relationship? How can I delete this column I no longer need?

Thanks in advance for any pointers or help. I always appreciate assistance here.

mg55345 is offline   Reply With Quote
Old 10-14-2008, 08:12 AM   #2
Kiwiman
Registered User
 
Kiwiman's Avatar
 
Join Date: Apr 2008
Location: Bath, UK
Posts: 799
Thanks: 8
Thanked 57 Times in 57 Posts
Kiwiman will become famous soon enough Kiwiman will become famous soon enough
Send a message via ICQ to Kiwiman
Re: How to Delete Fields with Relationships

Howzit

SOmetimes the relationship tables are hidden. In the relationship window, right click and select "Show All". See if this shows the tables
__________________
HTH's
Take It Easy
Pete
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Man who keep feet firmly on ground have trouble putting on pants.
Kiwiman is offline   Reply With Quote
Old 10-14-2008, 10:39 AM   #3
mg55345
Registered User
 
Join Date: Sep 2007
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
mg55345 is on a distinguished road
Re: How to Delete Fields with Relationships

Weird... but that worked! Got it.

Thanks so much!

mg55345 is offline   Reply With Quote
Old 01-29-2013, 03:40 PM   #4
ODP
Newly Registered User
 
Join Date: Jan 2013
Posts: 3
Thanks: 2
Thanked 0 Times in 0 Posts
ODP is on a distinguished road
Re: How to Delete Fields with Relationships

OK - got the same message. Deleted all the tables. Requested "show all". Nothing appeared. Scrolled to the right - nothing. Scrolled down - nothing. Scrolled back to beginning. Nothing. No object dependencies listed. Still will not allow field deletion.
After deleting all tables - saved and closed. Still unable to delete field. Soooo - what's up with that?? :-)

Thanks for any help and replying!! A.
ODP is offline   Reply With Quote
Old 01-30-2013, 06:58 PM   #5
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 27,394
Thanks: 13
Thanked 1,416 Times in 1,350 Posts
Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light
Re: How to Delete Fields with Relationships

You can't just delete the tables. That only hides them. To delete a relationship, you need to click on the relationship LINE and delet it.
__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
The Following User Says Thank You to Pat Hartman For This Useful Post:
ODP (01-31-2013)
Old 01-31-2013, 06:43 AM   #6
ODP
Newly Registered User
 
Join Date: Jan 2013
Posts: 3
Thanks: 2
Thanked 0 Times in 0 Posts
ODP is on a distinguished road
Re: How to Delete Fields with Relationships

AH HA!! Thank you so much!! I realize now this is a semantic thing and I need to pay better attention to those details - like learning a new language - never built a db before and it is definitely a trial and error thing!! Thanks again1
ODP is offline   Reply With Quote
Old 01-31-2013, 04:54 PM   #7
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 27,394
Thanks: 13
Thanked 1,416 Times in 1,350 Posts
Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light
Re: How to Delete Fields with Relationships

I still can't use a Mac because you close a file by dragging it to the trash bin


__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Delete fields referring to field number thh Tables 2 08-06-2006 01:19 AM
delete child record and later delete the parent record swathin Tables 0 09-01-2005 12:47 PM
Delete Fields from Table steallan Tables 5 08-30-2005 06:36 AM
Add and delete fields using VBA jimday1982 Modules & VBA 3 06-01-2004 09:59 AM
Delete only certain fields from a record azzurri General 2 01-10-2003 07:48 AM




All times are GMT -8. The time now is 04:52 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World