Where to start...

  • Thread starter Thread starter stephendeloach via AccessMonster.com
  • Start date Start date
S

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
 
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..
 
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)
 
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
Click to expand...
[quoted text clipped - 3 lines]
be a normalized way of setting it up? Thanks.
Stephen
Click to expand...
Click to expand...
 
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)




stephendeloach via AccessMonster.com said:
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
Click to expand...
[quoted text clipped - 3 lines]
be a normalized way of setting it up? Thanks.
Stephen
Click to expand...
Click to expand...
Click to expand...
 
Back
Top