Is there a way to link records in same table i.e. library databas.

[Guest]

I am trying to build a database for a file centre. We have files relating to
clients and I want to be able to cross relate files such as members of a
family. Is there a way to links records within the same table so that you
can link the records and when you look at the record for one file it will
tell me the files related to it. I am working within Microsoft Access 2002.

 

[Lynn Trapp]

If a file will be related to one and only one other file, then you can do
that by adding a field called ParentFileID to your table and entering the
value of the ID for the file it is related to. If a given file can be
related to more than one file, things get a bit more complicated.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

I am trying to build a database for a file centre. We have files relating to
clients and I want to be able to cross relate files such as members of a
family. Is there a way to links records within the same table so that you
can link the records and when you look at the record for one file it will
tell me the files related to it. I am working within Microsoft Access

2002.

 

[Guest]

Hi Lynn

Unfortunately, the files can be related to numerous other files. How would
I cope with this?

Ladyhawk