469,608 Members | 1,581 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,608 developers. It's quick & easy.

Multiple Parent/Child record-2-record links within same table


I am in the process of designing a database, within which I have created a table called "tblDOCUMENTS". As the title suggests, this is a list of documents (records) of varying types. I would like to cretae a many-to-many relationship 'within' the table.

All of the records are related to zero, 1, or more 'other' records...all of which are located within this table. In reality, there is no unique criteria which leads to the link, the documets simply reference one another within the text. I need a means of listing any 1 document, and thereby get a list of other documents which it references. :confused: Access 2003 does not appear to provide an easy method of doing this, so I present this question to those of you with more experience with Access 2003 (and programming for that matter).

* Please note that I'm a mechanical engineer by trade and any/all of my Access 2003 experience has been self-taught. I have no programming expertise and am 'learning as I go"...so please bear this in mind when replying with suggestions :o

Jul 7 '06 #1
0 1522

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by ahaideb | last post: by
reply views Thread by Karthick Kumar | last post: by
4 posts views Thread by Danny Tuppeny | last post: by
2 posts views Thread by Howard | last post: by
reply views Thread by Innova | last post: by
8 posts views Thread by Rick | last post: by
reply views Thread by devrayhaan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.