Checkbox Subfrom please help!

[blackwolf23]

Greetings. I have 2 tables " reports" and " occurrences " . I need to in the form for " reports" to have a subform in which the user selects a number of record from " occurrences " via a checkbox to be used further in the report made for "reports".

Please help me I looked everywhere but I have yet to find a concrete answer on the subject . I tried the checkbox type of data without the sub form , but my professor told me not to use it and besides " occurrences" has a lot of fields

 

[Ranman256]

The table tOccurences needs a field 'USE' as true/false.
Add this check box to the sub form.
User checks the occurrence they need.
The query for the report will join with tOccurence table and only use the items checked.

 

[blackwolf23]

The relationship between "reports" and "occurrences" needs to be a many to many relationship . I think I cant put a yes or no because one "occurrence" can and will be used in more reports

 

[Ranman256]

Then each report needs a custom list.

 

[blackwolf23]

Then each report needs a custom list.

Can you please elaborate. I am not very proficient with access. We only started databases in my It college.