473,320 Members | 1,952 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Table Relationship problem

15
Hi All,

I've been plugging away at this problem for a while now and was wondering if anyone had an idea they could share.

I'm working on a document management database that tracks revisions of Manuals. So here it goes..

There are a group of manuals that need to be maintained. Each manual has an associating set of tabs that relate to it. Each tab in turn has a set of chapters that relate to it.

A client can sign out an entire manual, or an entire tabs or specific chapters.

When a request comes in to revise these manuals/tabs/chapters, they need to be tracked as signed out so that no other client can make changes to them. The request usually carries more then one change with it (like to an entire manual, or an entire tab, or a set of chapters from several manuals).

Now so far i have 4 tables:
-Clients
-Manuals
-Tabs
-Chapters

They are linked as follows:
Client has a one to many relationship with Manuals, Tabs and Chapters Tables
Manual Table has a one to many relationship with the Tabs Table
Tabs Table has a one to many relationship with the Chapters Table

Now i need to create a table that monitor's the incoming request (as a batch). It should be able to assign a request an ID, and track the client's name, and the manual, tab or chapter they have signed out.

I will then use the request ID from this table and take it through two other revision processes (where other Auto ID's have to be assigned - Job ID, PublishedID)

I just don't know how to relate this table to the other's. Any help would be much appreciated.

Thanks,
Oz
Oct 10 '06 #1
2 1566
sanniep
48
Hi All,

I've been plugging away at this problem for a while now and was wondering if anyone had an idea they could share.

I'm working on a document management database that tracks revisions of Manuals. So here it goes..

There are a group of manuals that need to be maintained. Each manual has an associating set of tabs that relate to it. Each tab in turn has a set of chapters that relate to it.

A client can sign out an entire manual, or an entire tabs or specific chapters.

When a request comes in to revise these manuals/tabs/chapters, they need to be tracked as signed out so that no other client can make changes to them. The request usually carries more then one change with it (like to an entire manual, or an entire tab, or a set of chapters from several manuals).

Now so far i have 4 tables:
-Clients
-Manuals
-Tabs
-Chapters

They are linked as follows:
Client has a one to many relationship with Manuals, Tabs and Chapters Tables
Manual Table has a one to many relationship with the Tabs Table
Tabs Table has a one to many relationship with the Chapters Table

Now i need to create a table that monitor's the incoming request (as a batch). It should be able to assign a request an ID, and track the client's name, and the manual, tab or chapter they have signed out.

I will then use the request ID from this table and take it through two other revision processes (where other Auto ID's have to be assigned - Job ID, PublishedID)

I just don't know how to relate this table to the other's. Any help would be much appreciated.

Thanks,
Oz
I think I'm missing the point here but what about the following.. When a new request comes in a Request will be created in the Request table, this request gets it's own ID. The rest of the table should contain at least a ClientId, ManualId, TabId, ChapterId. You fill out these fields with the used Id's from the other tables and then you will have your relation... It's 7.30 in the morning here so maybe I'm talking nonsens but does this help?

Sander
Oct 11 '06 #2
uarana
15
I think I'm missing the point here but what about the following.. When a new request comes in a Request will be created in the Request table, this request gets it's own ID. The rest of the table should contain at least a ClientId, ManualId, TabId, ChapterId. You fill out these fields with the used Id's from the other tables and then you will have your relation... It's 7.30 in the morning here so maybe I'm talking nonsens but does this help?

Sander
Hi Sander,

I was thinking along the same lines. This is what i have constructed so far. I know that the ManualID, TabID and ChapterID need to be in the Job's Table. But the problem is, how will one JobID account for multiple chapters that have been signed out. Every record will have a unique ID, but will only be able to house info for one chapter signed out.

I'm trying to move a set of chapters in a capsule with one unique ID through revision phases.

Please disregard the ManualID and TabID in the tbl_Jobs in the picture below. Don't quite know what i was thinking having them there...

Oct 11 '06 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Fred | last post by:
Hi. How do I import while mapping an excel table to an access table please??? I've searched around and all I can find is a software product or code that does the same thing as the access...
2
by: Larry R Harrison Jr | last post by:
I have an Access 97 database with 2 tables that have a one-many relationship. I have a SQL statement in the "one" table which I want to execute and insert 7 records into the "many" table, and I...
4
by: Terry | last post by:
I need some help refining an MS 2000 relational databse. I have created a simple relational database using two tables, 'Student Details', 'Exam Details' and two forms, 'Input/Edit Exam Details',...
5
by: Sami | last post by:
Please bear with me, and if you answer this question, please do it step by step. I am new at Access, not at all sophisticated. I am using Office XP. This will need to be read in Access for...
8
by: Bri | last post by:
Greetings, I'm having a very strange problem in an AC97 MDB with ODBC Linked tables to SQL Server 7. The table has an Identity field and a Timestamp field. The problem is that when a new record...
5
by: PAUL | last post by:
Hello, I have 2 tables with a relationship set up in the dataset with vb ..net. I add a new record to the parent table then edit an existing child record to have the new parent ID. However when I...
117
by: phil-news-nospam | last post by:
Is there really any advantage to using DIV elements with float style properies, vs. the old method of TABLE and TR and TD? I'm finding that by using DIV, it still involves the same number of...
76
MMcCarthy
by: MMcCarthy | last post by:
Normalisation is the term used to describe how you break a file down into tables to create a database. There are 3 or 4 major steps involved known as 1NF (First Normal Form), 2NF (Second Normal...
17
by: Stubert | last post by:
I have a training module db that stores information about employees and what training they have carried our or need to carry out. One table in this database stores what training needs to be carried...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.