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

2 New Member

Folks,

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

Thanks

Jul 7 '06 #1

Subscribe Reply

1639

Similar topics

parent-child sophisticated SQL query?

by: ahaideb | last post by:

I have a table (relation) in my database: --------------- | parent | child | --------------- | 1 | 2 | | 1 | 3 | | 2 | 4 | | 2 | 5 ...

MySQL Database

Simpe parent/child menu displayed based on parent item

by: Karthick Kumar | last post by:

Hi, I need to create a simple parent/child hierarchical menu. I have alread used the Treeview control but my requirement is slightly different than the Treeview control. I already have the kind...

C# / C Sharp

Code Review! Parent-child relationships

by: Danny Tuppeny | last post by:

Hi all, I've been trying to write some classes, so when I have a parent-child relationship, such as with Folders in my application, I don't have to remember to add a parent reference, as well as...

C# / C Sharp

Getting data table parent child relations tostring?

by: What-a-Tool | last post by:

I am trying to write a program that will take all the members of a data base, add them to a tree, with all child relations as sub-nodes. I am having a problem getting the parent child relations...

Visual Basic .NET

multiple parent categories

by: Howard | last post by:

how would you design a table that allows an item to belong to multiple parent categories. single parent example: select * from table1 where parentid = 5 in this case parentid is an indexable...

.NET Framework

Parent Child GridView Issue

by: Innova | last post by:

Hi, We are working on a gridview inside the gridview (parent-child) scenario. The data of child grid will depend on the data of parent. Objectives: 1.Add new row in parent grid after each row...

.NET Framework

Navigating parent-child relation to update the child records --- How???

by: Hexman | last post by:

Hello All, What I'm trying to do is update a child record using a parent-child relation. I want to find out if it is faster than than doing multiple selects. Anyways, I've created a dataset...

Visual Basic .NET

Parent Child tables and Saving Table

by: heather2007 | last post by:

Hello, I am a novice, but trying my best. I am trying to make a patient table and doctor visit table for each patient, so I can log all visits for patients coming to our office....so parent table...

Visual Basic 4 / 5 / 6

parent/child grids

by: Rick | last post by:

VS 2005 I' m setting up a parent/child datagridviews in a form. I am doing a lot of this by hand coding in order to get the feel of things. I want a change in the parent table to trigger a...

Visual Basic .NET

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp