I have a table that contains 12 records that define begin and end dates for a conference that occurs in different states of each year. It's like a schedule for 1 conference that happens in 12 places each year.
The table also contains the state name and a year (ie. 2012 - because the activity may start in the next year but it is still considered part of the 2012 schedule).
The table has ID, statename, begin date, end date, year.
I want to have a form where the user enters a year (2012) and the 12 rows that correspond to that year lists below it.
Is that considered a form/subform design even though I don't have 2 tables? Can you point me to some sample forms?
The table also contains the state name and a year (ie. 2012 - because the activity may start in the next year but it is still considered part of the 2012 schedule).
The table has ID, statename, begin date, end date, year.
I want to have a form where the user enters a year (2012) and the 12 rows that correspond to that year lists below it.
Is that considered a form/subform design even though I don't have 2 tables? Can you point me to some sample forms?
