Search results for query: *

Thanks for the tips, things seem to be working well so far.

I have setup the relationships in a way that I belive is correct. I know that the whole datbase depends on these relationships. I would like to show the layout to you to get some feedback. I have 8 tables I'll give them a number to make the relationship discussion easier. Table #1 -...

I was thinking that I could create a deal table. DealTable DealID - PK SupplierID - FK PointID - FK a few other deatails such as the transaction date, volume, price etc. That could relate to the deals table to the Supplier Table via supplierID. That would be a one on the supplierstable side...

I was looking things over and realized that I forgot about the deals that we need capture in our database. The supply for the supply points needs to come from somewhere in order to be able to deliver the gas. We basically just track the pipeline that the gas is going into, the date of...

Thanks again John. That seems to be right on target for what I am looking for. If I want to keep tract of the supplier that is supply the gas at the supply point I would just add a Supplier table with a SupplierID as a primary key. That SupplierID would than be the foreign key in the...

First, I want to thank you for the help johnherman. That was greatly appreciated. Secondly, I want to apologize for being such a "newbie". I have one problem that I couln't get around today. I'll give an example. On contract 19 we have supply that we are purchasing from supplier S at point...

I am trying to design a database that would help track the daily supply of natural gas on multiple contracts. Each contract has a supply side and a delivery side which are equal in volume (when fuel is taken into account). My problem begins with the fact that each contract has a different...