Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a list of activities that each contains a startdate and an enddate.
I'm trying to implement a master calendar, but I can't figure out how to connect
the year field in the master calendar to both the startdate year and enddate year.
In my year listbox I can select a year but it only shows activities with enddates in that year,
where I want it to show all activities that has either a startdate or enddate or both, in that year.
Thanks.
Sorry got a bit distracted at work.
See the attachment.
You need to create your own private key if you have nulls
RowNo() AS Key...
Shouldn't it still work if I just leave it as you wrote, or do I need to change the key?
I have uploaded the document to load from the table in this thread.
How can an activity have an end date and no start date and seems a little illogical. ?
Can't you set the date to a default date if it is null ?
There are some activites that contains enddates but no startdates.
In case of no startdate, I could possibly create a temporary startdate that has the same year as the enddate, but it should then be overwritten if an actual startdate pops up in the data.
That sounds very sensbile, I think you'll find the data model will work then. Also I notice you have a synthetic key, you can drop the temp data to get rid of this.