You are correct chris. The second table is result table & first table is main table. I give you an example to make this clear.

@10 am User creates an entry for date range 10/10/2002 to 10/15/2002 with qty 15. After 1 hour or next day, he thinks few dates should contain high qty so creates one more record for date range 10/12/02 to 10/14/2002 with qty 28.

ie last entry always wins

After he saves the record through gui, he will expect to see in the below format

10/10/2002 10/11/2002 15
10/12/2002 10/14/2002 28
10/15/2002 10/15/2002 15

As per spec, once user added a record, he cannot update.
If i get a solution for this, i would solve my performance issue. Please help me..........

Have a nice day