Append Query/Relationships

T

TotallyConfused

Hi I have been trying to append from a flat file to several tables. I have
deleted the relationships. However there are two tables where I can't remove
the primary key and I get the following message saying " You can't change the
primary key. This table is the primary table in one or more relationships.
If you want to change or remove the primary key, first delete the
relationship in the relationships window."
Why am I getting this if I have removed the relationships and tables from
the relationships window. What do I do with this? Any help will be greatly
appreciated.
 
G

Gina Whipp

TotallyConfused,

Open the Relationships Window... find and press the Show All Relationships
button. Delete the Relationships and that should solve your problem.

Of course, I would not want to remove my relationships but figure out why I
could not append my data. Putting those relationships back could prove more
work then you want.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
Top