Where to start...

  • Thread starter stephendeloach via AccessMonster.com
  • 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
 
S

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

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
[email protected]
 
S

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
[email protected]
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...
 
S

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
[email protected]




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
[email protected]
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...
 
Top