do things look normal?

J

justin

I just wanted to post my tables and their relationships to
get some feedback from the pros on whether or not this
database is headed in the right direction. Thanks for the
help in advance.

tblcontractinfo
DocumentID (autonumber) (primary key)
Documenttype
documentname
CSFScontactname
CSFSprojectcontact
CSFSoffice
OtherPartyContactName
AccountNumber
POnumber
DollarAmount
DocumentActive
Enteredby

tblcontractdates
DocumentID (primary key)
recieveddate
startdate
enddate
routedate
routecompletiondate

tblcomments
ID (primary key)
comments
date
name

tblcontracttype

tbloffices

these last two tables are used as drop down menus on the
form.


The DocumentID fields in the tblcontractinfo table and
tblcontractdates table are related in a one to one
relationship. The ID field form the tblcomments table is
related to the DocumentID field in tblcontractinfo table
in a one to one relationship as well.

Well that's it. What do you think? Thanks for the advice.

-justin
 
D

Duane Hookom

I don't care for:
tblcontractdates
DocumentID (primary key)
recieveddate
startdate
enddate
routedate
routecompletiondate
I would expect as soon as you deply this application, some pointy-haired
boss will need to track another date which will cause redesign of tables,
forms, queries, reports,...

A more flexible solution would have a table like
tblContractDate
DocumentID
DateType
EventDate

Then add a table of date types for a lookup.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top