Multiple dates in a table, how to store ?

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?
 
J

John Vinson

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?

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top