Database design

K

Kaz

I need to create a database for the various policies in
our organisation, not sure where to start as I am pretty
new at access.
There are several departments which are broken down into
sections. eg Support & Planning = I.T,Finance, Stores, etc
Each section has 1 or more policys.
I need a link to the policy as a word doc and short a
description of the policy.
Users need to be able to access the policys on the
intranet.
Any help in pointing me in the right direction would be
appreciated.
 
D

Duane Hookom

How about
tblDepartments
dptDptID autonumber PrimaryKey
dptTitle

tblSections
secSecID autonumber primarykey
secDptID foreign key to tblDepartments.dptDptID
secTitle

tblPolicies
polPolID autonumber primarykey
polTitle
polFileName

tblPolSec
posPoSID autonumber primarykey
posPolID foreign key to tblPolicies.polPolID
posSecID foreign key to tblSections.secSecID
 

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