Thanks Allen, your suggestion makes perfect sense but I forsee that being a
problem when I'm creating the reports. How do I indicate that the incident
occured in the report? I'm certain the report query will bring up the
corresponding frequency provided the incident occured, however I would like
to display a checked checkbox alongside the frequency. How can this be done?
Sorry if my questions are too basic, I'm a newbie in this field.

"Allen Browne" wrote:

Instead of a Yes/No field and then a Number field to record how many, could
you get away with just the Number field?

If the answer was No, presumably the Number is zero. It seems to me that
this would be a better (more reliable) design, as it would prevent the
existence of bad data (e.g. where the Yes/No field contains No, but the
Number field contains 8.) Having just the Number field avoids that kind of
inaccuracy.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"omoluabi" wrote in message
...
Hi all,
I'm designing a database that requires users to specify the number of
times
a Yes/No field occurs. This number is not required if the choice is No but
if
Yes, I plan to create a drop down menu for the user to specify the number
of
times the choice occured.
My first thought is to create a Frequency field for each choice but then I
thought there must be a better way to do it. I came up with an idea to
create
a Frequency table (tblFrequency) described below:

tblFrequency:
Field: FreqID
Field: Freq

I'm planning to make FreqID a foreign key on my Incidents table which
contains the choices (Yes/No) fields.

The problem is that I'm somewhat short of ideas on how to make this work.
Thanks for your patience.

.