database setup...

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

stephendeloach via AccessMonster.com

I am going to make a database to enter numbers daily. What I need is a form
that has the Oil Field Name and Well Name (stays the same), under that I need
fields for Time, T.P., C.P., Oil, SW, MCF, Remarks. Im kind of confused on
how to set it up. I have it in Excel now and down the left side are my Oil
Field & Well names with Time, TP, CP, OIL, SW, and MCF across the top and
numbers under them for each well... if this makes any sense could someone
direct me in a direction? Thanks
 
TblOilField
OilFieldID
OilFieldName

TblWell
WellID
OilFieldID
WellNmae

TblWellLog
WellLogID
WellID
LogTime
TP
CP
Oil
SW
MCF
Remarks

Join OilFieldID in TblOilField to OilFieldID in TblWell. Join WellID in
TblWell to WellID in TblWellLog.

First create a form/subform from TblWell and TblWellLog. Then make this
form/subform a subform on a form based on TblOilField. You will then be able
to go to an oil field, see all the wells in that oil field and see the log
for the current well.

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