title: Stuck in database design, Unable to query result
body: <p>I designed my database, in which I have 4 quarters in a year, and I have 3 values for year i.e </p>
  
  <pre><code>2015 (Quarter 1) | 2014 (Quarter 1) | 2013 (Quarter 1)
  </code></pre>
  
  <p>It is like, if I chose 2014 (Quarter 1) it would be like</p>
  
  <pre><code>2014 (Quarter 1) | 2013 (Quarter 1) | 2012 (Quarter 1).
  </code></pre>
  
  <p>Same goes for other quarters. My database table is like:</p>
  
  <pre><code>First_Year | Second_Year | Third_Year | For_Year | Quarter_Year | CODE 
  12         | 15          | 16         | 2015     |      1       | Interest_Earned
  6          | 5           |  6         | 2015     |      1       | Interest_Expense
  </code></pre>
  
  <p>Now lets say, my <code>First_Year = For_Year</code> (2015 in this case), my <code>Second_Year = For_Year - 1</code> (become 2014 in this case) and my <code>Third_Year = For_Year - 2</code> (2013 according to mentioned table).</p>
  
  <p>I want to query these results and populate in ASP.NET TextBoxes with help of PL SQL. Lets say user chose Quarter 1 and Year 2015 on front end via DropDown list, I have to select data for Quarter 1 and 2015, which is easy, and all other fields too.</p>
  
  <p>But if I am going to enter data for year 2016, I would have data available for 2015 and 2014 in advance (see in table I have data available). When I will be entering data for year 2016 I should not re-enter data for year 2015 and 2014. That's where I would stuck, because I can't copy my data again and again. I would have no issue to copy data again and again for sake of completing it, still I am clueless. How would I only choose related data to populate my TextBoxes and report.</p>
  
  <p>Lets say, I choose 2016 data, so in this case, I will have to populate my TextBoxes, related to data of 2015 and 2014, but because I'll have no data available for year 2016, TextBoxes of that part will be empty. Kindly help me out in it.</p>
  
  <p>Should I change my design? I completed around 80% of my work and now I am facing hard deadline.</p>
  
  <p>In easy words, I am making Capital Adequacy Report on Capital Risk Operations.</p>