Where to start...

[stephendeloach via AccessMonster.com]

I am making a new database and need a little help on the design... Im going
to need to see what type of rig (Drilling, Swab, and WorkOver) on a form that
shows the rigs name, make, serial#, ManufactureDate, Model, etc... what would
be a normalized way of setting it up? Thanks.
Stephen

 

[stephendeloach via AccessMonster.com]

Another note.. I will have different names for WorkOver (Rig #1 - #20) and
different names for Swab (Rig #1 - #5) and different names for Drilling (5
different names)... if that helps any..

 

[Steve]

TblRigType
RigTypeID
RigType Drilling, Swab, and WorkOver

TblRigModel
RigModelID
RigTypeID
RigModel

TblRig
RigID
RigTypeID
RigName
RigSN
RigMfgDate
RigModelID
etc

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[stephendeloach via AccessMonster.com]

OK.. now I have my tables made. I would link them by RigType - RigTypeID,
RigModelID - RigModelID? Just to keep in mind, the form has to be pretty
basic and simple for someone to understand and work. Thanks for the time...

Stephen

TblRigType
RigTypeID
RigType Drilling, Swab, and WorkOver

TblRigModel
RigModelID
RigTypeID
RigModel

TblRig
RigID
RigTypeID
RigName
RigSN
RigMfgDate
RigModelID
etc

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

I am making a new database and need a little help on the design... Im going
to need to see what type of rig (Drilling, Swab, and WorkOver) on a form

[quoted text clipped - 3 lines]

be a normalized way of setting it up? Thanks.
Stephen

 

[Steve]

Now create a form based on TblRig. Use a combobox or listbox to enter
RigTypeID and RigModelID.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

OK.. now I have my tables made. I would link them by RigType - RigTypeID,
RigModelID - RigModelID? Just to keep in mind, the form has to be pretty
basic and simple for someone to understand and work. Thanks for the
time...

Stephen

TblRigType
RigTypeID
RigType Drilling, Swab, and WorkOver

TblRigModel
RigModelID
RigTypeID
RigModel

TblRig
RigID
RigTypeID
RigName
RigSN
RigMfgDate
RigModelID
etc

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

I am making a new database and need a little help on the design... Im
going
to need to see what type of rig (Drilling, Swab, and WorkOver) on a form

[quoted text clipped - 3 lines]

be a normalized way of setting it up? Thanks.
Stephen