Min Date Function
I have created a database to manage events for an AV company. The relationship in questions consists of one event having many components. Each component has a variety of dates, for example, a "Start Date."
On the "Event Overview", I have a "Major Times and Dates" section, that I would like to show data related to the components. For instance, I would like the "Global Start Date" on the "Event Overview" to show the minimum "Start Date" value from the related components.
For one reason or another, I am unsuccessful when using the "Min (Components::Start Date )" function.
I am relatively new to databases and am curious what I am missing. I'm sure you will need more information, please let me know what information you need to help solve this problem.
Thank you in advance!