recurrent events calendar

[schalkse]

Hi guys, ..and girls

i have a calendar that works like a charm, but i would like to add the possibility to add recurrent events in it.
for instance if a user has to perform a task at a choosen time schedule, it is shown in the agenda, like each week or each two weeks or each month.
Anybody any idea how i would aproach this problem or has a sollution?

Thanks

 

[schalkse]

ok, have one working after 2 days of searching.
Now i have two tables, on holds my calendar and one my events. query on both returns what i want. How do i joing both queries (since both have same fields) and that one single query returns the results. I think a join query should do the trick, but anybody have a good example or an idea on how to accomplish this?