How to tag an interval of data according to a table

[#1]

Hello,

I have a Table with distinct data like:

[AllData]:

Index	Information
1	a
2	b
3	c
4	d
5	e
6	f
7	g
8	h
9	i
10	j

I also have another table that states when somthing happened like:

[Situation]:

Index	Situation
0	X
2	Y
5	X
8	Z

What i need to do is join these two tables adding the "situation" to all index between the interval in its table, like the following:

[Result]:

Index	Information	Situation
1	a	X
2	b	Y
3	c	Y
4	d	Y
5	e	X
6	f	X
7	g	X
8	h	Z
9	i	Z
10	j	Z

Long story short, the situation reffers to all the next statements until a different situation appears.

I want to do this using the tables already loaded since the first and second table use some calculated information. I've been trying to use the Load Resident but haven't been succesful.

Thanks for your help.

André Gaspar