G
gianfranco.spiteri
Hi,
I have a form with ten checkboxes (referring to different age-groups)
and need a way to allow the user to select only one of them. User
cannot select more than one or none. I cannot use an option group
because these checkboxes are all linked to different fields in the same
table. They need to remain in different fields because i need to
compare the age-groups with another table containing data with these
agegroups.
is there any solution to this? or maybe a way of redesigning my db?
Gianfranco
summary of db: the database is made of 2 tables. Table 1 contains cases
of influenza with fields for age, GP code, locality, week number,
vaccination and agegroups (there is a field for every agegroup and you
need to select one only). Table 2 is made up of fields for GP code,
week number, and agegroups (again field for every age group and each
field contains the number of patients the particular GP has seen in
that particlar age group in that particular week)
My aim is to calculate incidence of influenza by dividing the number of
cases of flu in a particular week (from table 1) by the total number of
patients seen in that particular week (from table 2))
I have a form with ten checkboxes (referring to different age-groups)
and need a way to allow the user to select only one of them. User
cannot select more than one or none. I cannot use an option group
because these checkboxes are all linked to different fields in the same
table. They need to remain in different fields because i need to
compare the age-groups with another table containing data with these
agegroups.
is there any solution to this? or maybe a way of redesigning my db?
Gianfranco
summary of db: the database is made of 2 tables. Table 1 contains cases
of influenza with fields for age, GP code, locality, week number,
vaccination and agegroups (there is a field for every agegroup and you
need to select one only). Table 2 is made up of fields for GP code,
week number, and agegroups (again field for every age group and each
field contains the number of patients the particular GP has seen in
that particlar age group in that particular week)
My aim is to calculate incidence of influenza by dividing the number of
cases of flu in a particular week (from table 1) by the total number of
patients seen in that particular week (from table 2))