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
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