Standard Operating Procedures - How to Manual
in [Tables]
|
From: Joseph on 1 Jul 2008 18:18 I have been working on an SOP for about 3month now and am getting frustrated at it. The problem is that when I need to change something, formating the page, column, tabs(!!!), numbering(!!!), it needs to be conguent with the rest of the document. Unfortuantly it is not working to my expectation with MSWord and OpenOffice Writer(even with their master/child document template). What I would like to know is what would be better for formating? Expl: Chapter 1 Chapter Title Policy Text text text Procedure A. Text text 1. Text text i. Text text a. Text text I. Text text (arrow) Text text Plan A: One table for each chapter limited only by the amount of fields Plan B: One table for each sub-line limited only by (How would I link the tables together?) What indexes would be used? Any help would be gratefull.
From: John W. Vinson on 1 Jul 2008 19:20 On Tue, 1 Jul 2008 15:18:01 -0700, Joseph <Joseph(a)discussions.microsoft.com> wrote: >I have been working on an SOP for about 3month now and am getting frustrated >at it. The problem is that when I need to change something, formating the >page, column, tabs(!!!), numbering(!!!), it needs to be conguent with the >rest of the document. Unfortuantly it is not working to my expectation with >MSWord and OpenOffice Writer(even with their master/child document template). > Please repost your question in a forum supporting the software you're using. This newsgroup is for a different program, Microsoft Access. The webpage can be confusing and may have misled you; scroll down the list of subjects and find one for Word or Publisher or whatever program you're using. -- John W. Vinson [MVP]
From: John W. Vinson on 1 Jul 2008 23:15 On Tue, 1 Jul 2008 15:18:01 -0700, Joseph <Joseph(a)discussions.microsoft.com> wrote: >I have been working on an SOP for about 3month now and am getting frustrated >at it. The problem is that when I need to change something, formating the >page, column, tabs(!!!), numbering(!!!), it needs to be conguent with the >rest of the document. Unfortuantly it is not working to my expectation with >MSWord and OpenOffice Writer(even with their master/child document template). > > >What I would like to know is what would be better for formating? >Expl: >Chapter 1 > Chapter Title > Policy > Text text text > Procedure > A. Text text > 1. Text text > i. Text text > a. Text text > I. Text text > (arrow) Text text > >Plan A: > One table for each chapter > limited only by the amount of fields >Plan B: > One table for each sub-line > limited only by (How would I link the tables together?) What indexes >would be used? > >Any help would be gratefull. > > My apologies for my over hasty previous answer. I really DON'T think that this very free-form data structure lends itself very well to relational data. If it is done in relational tables though you would certainly *NOT* have one table per chapter nor one table per subline!!! Do a google search for "access bill of materials". There are ways to put heirarchical data like this into a single Access table. It's tricky and too lengthy to explain here, even if I remembered the details, which I don't. -- John W. Vinson [MVP]
From: Joseph on 2 Jul 2008 16:54 > My apologies for my over hasty previous answer. > > I really DON'T think that this very free-form data structure lends itself very > well to relational data. If it is done in relational tables though you would > certainly *NOT* have one table per chapter nor one table per subline!!! > > Do a google search for "access bill of materials". There are ways to put > heirarchical data like this into a single Access table. It's tricky and too > lengthy to explain here, even if I remembered the details, which I don't. > -- > > John W. Vinson [MVP] Thank you for your answer. I know that it is will be a very difficult database to envision, but possible. I could not find an downloadable template for the above mentioned, only alot of companies offering full or demo products as such. Thank you again
From: Mark on 2 Jul 2008 21:06
I can set this up for you for a very reasonable fee. I did this recently for someone wanting to automate creating contracts. The solution included integrating Word and Access. I provide users a resource for help with Access, Excel and Word applications. If you would like my help, contact me at rlaird(a)penn.com. Steve "Joseph" <Joseph(a)discussions.microsoft.com> wrote in message news:7917A07B-C3B5-47A4-9DA2-3D79A1840358(a)microsoft.com... >> My apologies for my over hasty previous answer. >> >> I really DON'T think that this very free-form data structure lends itself >> very >> well to relational data. If it is done in relational tables though you >> would >> certainly *NOT* have one table per chapter nor one table per subline!!! >> >> Do a google search for "access bill of materials". There are ways to put >> heirarchical data like this into a single Access table. It's tricky and >> too >> lengthy to explain here, even if I remembered the details, which I don't. >> -- >> >> John W. Vinson [MVP] > > Thank you for your answer. I know that it is will be a very difficult > database to envision, but possible. I could not find an downloadable > template for the above mentioned, only alot of companies offering full or > demo products as such. > > Thank you again |