Multiple dates in a table, how to store ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table called 'Rules'. There are six different rule 'types'. Some
data is common to all rule types and some is unique. Each rule type has a set
of up to 20 dates as part of the data. Rather than have my forms cluttered
with all these dates, I'd like to store the dates in a separate table and use
a listbox to populate them via a calendar control. My question is how to do
the updates since it will not be possible to bind the dates to the form.
Should I use a subform?
 
I have a table called 'Rules'. There are six different rule 'types'. Some
data is common to all rule types and some is unique. Each rule type has a set
of up to 20 dates as part of the data. Rather than have my forms cluttered
with all these dates, I'd like to store the dates in a separate table and use
a listbox to populate them via a calendar control. My question is how to do
the updates since it will not be possible to bind the dates to the form.
Should I use a subform?
Click to expand...

It sounds like you have a many-to-many relationship between RuleTypes
and Dates... right?

Yes, you'll probably need a subform, perhaps nested subforms. I'm not
at all sure how your tables might be related though!

John W. Vinson[MVP]
 
Back
Top