1
Help using this forum / How to create a relational database?
« on: January 07, 2023, 06:51:29 am »
I'm trying to create a relational data base so I can keep track of individual wells and the income from each of them. I have no problem creating the tables. However, I can't seem to get the relations to work. The well name will have lots of Production Dates. Can someone help me get thru this? Do I need another field?
Table for well info:
ID (PK)
ID Number
Well Name
Operator
Location
County
State
Interest
Type
Book
Page
Date Acquired
Date Sold
Owner Number
Notes:
Table for Income:
ID Number (PK)
Date Production
Rec Date
Gross Gas Rev
Gas Taxes
Liquids Gr Rev
Liquids tax
Other Deductions
Gross Oil Rev
Gross Oil Tax
Operating
Other Income
Net MCF
Net BBLS Oil
Gross $/MCF
Gross $/BBL
Intangible Expense
Tangible Expense
Leasehold
Table for well info:
ID (PK)
ID Number
Well Name
Operator
Location
County
State
Interest
Type
Book
Page
Date Acquired
Date Sold
Owner Number
Notes:
Table for Income:
ID Number (PK)
Date Production
Rec Date
Gross Gas Rev
Gas Taxes
Liquids Gr Rev
Liquids tax
Other Deductions
Gross Oil Rev
Gross Oil Tax
Operating
Other Income
Net MCF
Net BBLS Oil
Gross $/MCF
Gross $/BBL
Intangible Expense
Tangible Expense
Leasehold