Simple relational question
I thought this could be done without a problem, but perhaps not. I have an orders table that has date fields for ENTERED DATE and DUE DATE. I'm trying to build a calendar to view these dates on a daily basis (i.e. what was entered today and what is due today) . I should be able to relate a single date field in a calendar table to two different date fields in the orders table, no?