-
Table Design
I need some help laying out the design of my tables. Here is what I have so far.
DOCUMENT
DOC_NUM
DOC_TITLE
DOC_CYCLE
DOC_ORGDATE
DOC_TYPE
DOC_DESIGNER
DOC_CHECKER
EMPLOYEE
EMP_NO
EMP_LNAME
EMP_FNAME
EMP_EMAIL
PROGRAM
PROG_NAME
PROG_DESC
PROG_MANAGER
PROG_CONTRACT_NO
Each document will have multiple Authorizers. Each authorizer has an alternate, 1st manager and 2nd manager. Each authorizer might sign off on the document on different dates so each document will have multiple sign-off dates tied to authorizers.
Do I create a fourth table that looks like this?
AUTHORIZATION
DOC_NO
DOC_AUTHORIZER
DOC_ALTERNATE
DOC_MANAGERA
DOC_MANAGERB
I want to ensure that the table design is correct to avoid data redundancies.
Any help would be appreciated.
-
dbGrul:
First (correct me if I am wrong), U want to know how to set up you tables.
If that is the case, first, open up Access, then click on new project, then save the project with a name. Second; click on tables,then new, then design veiw.Table one will open.
In this table I would do the following:
(you have to have a "PRIMARY KEY". A primary key will tie all your tables together when it comes to making relationships between tables.)
Your first table would consist of:
Name: Data
DocId AutoNumber
DocNum Number
DOC_TITLE Text
DOC_CYCLE Text?? (don't know what u mean by cycle??)
DOC_ORGDATE Date/time
DOC_TYPE Text
DOC_DESIGNER Text
DOC_CHECKER Text
I hope this help you
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|