Multiple answers in one field?

[stubeard]

Hey everyone.



By way of introductions, I'm a PhD student setting up an Access file for my bibliography. Basically I want to attach "tags" to each entry to say what subject area the book is related to, so that I can do a quick search to see which books come under which subject.

However, some come under more than one. For example: Alexis de Tocqueville's Democracy in America comes under the subject "democracy" but also under "political organisation". So I'd want this book to come up in a search for both terms.

Is there a way I can give an entry more than one "tag" like you can with mp3s in Windows Explorer, giving them more than one genre? And is there a way I can do it without setting up a field for each subject heading with a Yes/No answer?

[Rixxe]

I've never seen anything that suggests you can use a 'tag' (more than 1 result) in any field.
You could however, use an IF statement.
To say for example:

IF subjectarea1 <> null
then
insert into
IF subjectarea2 <> null
else
insert into
subjectarea3


Thats just an idea (That isnt proper syntax btw!) It means you wouldn't need a field for each subject area, but you would need more than one field, depending on how many areas an item can come under.
Either way its going to be difficult (my guess anyway) as you will have to specifiy each subject area that could go into any field depending.

Good luck

Rixxe