 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Database Design / May 2007Where to start...
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.. >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 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 resource@pcdatasheet.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 [quoted text clipped - 3 lines] > be a normalized way of setting it up? Thanks. > Stephen 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 [quoted text clipped - 24 lines] >> be a normalized way of setting it up? Thanks. >> Stephen 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 resource@pcdatasheet.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 [quoted text clipped - 32 lines] >>> be a normalized way of setting it up? Thanks. >>> Stephen |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.