Help with design

[Karen]

I am setting up a Database for all booklets and leaflets
in the office. The booklets come under different
categories eg Age, Gender, Race etc, some of them come
under more than one category. I had thought of checkboxes
where you can tick more than 1, but I am unsure if this is
the best way to go about it.
Any Help would be appreciated.

 

[John Nurick]

Hi Karen,

If there's a fixed list of categories that will never change, you can
include a Yes/No field for each category in your main table, and put a
checkbox for each on your form(s).

But if the categories are liable to change (e.g. if one day management
decide you need more categories), doing it this way means that every
time the categories change you need to modify your table and forms. In
tat case it's simpler in the long run to keep the categories as records
in a second table rather than fields in the main table, with a
many-to-many relationship between the booklets table and the categories
table.