Finding Links that are not in Links Window

[John Baker]

Hi:

I wish to remove a field from a record, however when I try I am told that I cant remove it
until I remove links to other records, and that the links will be showin in the links
will show up in the Relationships window. Unfortunatley, they dont!

Does anyone know of any tools to find all the links to a particular table? It may be that
I need to reset something to make them appear, in which cvase I would love to know what to
reset and how!!

Help much apprectaited

John Baker

[Danny J. Lesandrini]

Are you asking about table links to remote mdb files or the linking
that occurs when you set a Primary Key/Foreign Key relationship
between tables?

--

Danny J. Lesandrini
dl*********@hotmail.com
http://amazecreations.com
"John Baker" <Ba******@Verizon.net> wrote in message news:lt********************************@4ax.com...

Hi:

I wish to remove a field from a record, however when I try I am told that I cant remove it
until I remove links to other records, and that the links will be showin in the links
will show up in the Relationships window. Unfortunatley, they dont!

Does anyone know of any tools to find all the links to a particular table? It may be that
I need to reset something to make them appear, in which cvase I would love to know what to
reset and how!!

Help much apprectaited

John Baker

[John Baker]

Danny:

These are links within the system (i.e on the same computer and in the same Access mdp
file). Database and application are together at the moment, since the system is under
development. No remote links exist!

Anything you can do to point me in the right direction would he of help.

Regards

John Baker

"Danny J. Lesandrini" <dl*********@hotmail.com> wrote:

Are you asking about table links to remote mdb files or the linking
that occurs when you set a Primary Key/Foreign Key relationship
between tables?

[Danny J. Lesandrini]

What do you mean by "remove a field from a record"?

--

Danny J. Lesandrini
dl*********@hotmail.com
http://amazecreations.com
"John Baker" <Ba******@Verizon.net> wrote ...

Hi:

I wish to remove a field from a record, however when I try I am told that I cant remove it
until I remove links to other records, and that the links will be showin in the links
will show up in the Relationships window. Unfortunatley, they dont!

Does anyone know of any tools to find all the links to a particular table? It may be that
I need to reset something to make them appear, in which cvase I would love to know what to
reset and how!!

Help much apprectaited

John Baker

[John Baker]

I am attempting to reconstruct the links and some of the fields because the sturcture is
massivly confusing at the moment. I want to totally get rid of the field (and in some
cases tables) so that they are no longer present!

JOhn

"Danny J. Lesandrini" <dl*********@hotmail.com> wrote:

What do you mean by "remove a field from a record"?

[Danny J. Lesandrini]

So when it tells you can't remove the field, it's because the field
participates in a relationship with another table, either as a Primary
or Foreign key.

Go to the relationships window, find the field you want to delete,
remove all relationship lines by deleting them. Now you can remove
the field ... however, you also just removed your referential integrity.

This is OK, so long as you don't try to use your application until you
get it all put back together.
--

Danny J. Lesandrini
dl*********@hotmail.com
http://amazecreations.com
"John Baker" <Ba******@Verizon.net> wrote in message news:rr********************************@4ax.com...

I am attempting to reconstruct the links and some of the fields because the sturcture is
massivly confusing at the moment. I want to totally get rid of the field (and in some
cases tables) so that they are no longer present!

JOhn

"Danny J. Lesandrini" <dl*********@hotmail.com> wrote:

What do you mean by "remove a field from a record"?

[John Baker]

Thanks:

Just cut the astrings and then rety them I guess.

Thanks again

John
"Danny J. Legendarily" <dl*********@hotmail.com> wrote:

So when it tells you can't remove the field, it's because the field
participates in a relationship with another table, either as a Primary
or Foreign key.

Go to the relationships window, find the field you want to delete,
remove all relationship lines by deleting them. Now you can remove
the field ... however, you also just removed your referential integrity.

This is OK, so long as you don't try to use your application until you
get it all put back together.