Populate a calendar Image with specific date events
I want to copy a field content from an Events Table to populate an image of a calendar, and have that event show up on the specific day of the year on that calendar. Table 1 is Events and the fields are date, day of the year, and event description. Table 2 is Days of the Year with 365 fields as day and 365 as events (i.e., day1 and event1, day2 and event 2...). I have tried without success to create a many-to many relationship. Any help would be appreciated.