Many check boxes, I need help joining

[cntrintern]

I have several check boxes for the user to choose from. These are to match up with a table and then show an end result of matches on many levels. There are almost 20 checkboxes and I am only allowed to join 10 of these in the relationships window before getting booted out of access.
How do I get past this problem?

Please Help.
Thank you.

-Cassie

 

[mymou]

I must be missing something.

Why do you need joins in the relationships window? Shouldnt they just be criteria?


Stew

 

[cntrintern]

I am making a search by allowing the user to check many boxes that are categories under which resources are listed.
A resource can be one or many categories usually many.
I did another database similar to this with only two or three choices and it worked by making a query.
I had two tables in the query one with the [categories selected] and the other was the [resource directory] which held all the resources to search. The query would then filter out the matching records for the one or two categories by linking or joining those categories. This may have been a long way to do it, I am new Access and this was my solution at the time. But this is what I was attempting with this current database and the many checkboxes, but I could only join 10 categories at a time. I hope this clarifies. How would I do it if it was criteria?

Thank you.

-cassie

 

[mymou]

I assume that all category information is stored in one field (lets call it [Categories])

You could use Expressions in your query (in field in your query).
Category1: IIf([Categories]='1';True;False)
Category2: IIf([Categories]='2';True;False)
etc

With the appropiate criteria (in criteria in your query)
[forms]![frmFormName]![FieldName1]
[forms]![frmFormName]![FieldName2]
for each column.

Does that make sence? I just means that you need no joins.


Stew

 

[cntrintern]

Oh, wow, I didn't know you could make it into one field. I had each category be a different field. I will try to make it one field and now I understand the criteria part. Thank you for your help. I will try it out.

Thank you!!

-cassie