Hi! I have a problem with getting the data I want to be displayed in the reports. Let me explain the situation first. My whole db is about sites.
Each site has one project code and one contracter attached to them.
What I would need to do is that I could need to create a form where the user would be allowed to choose 5 sites from combo boxes. Then when the user clicks on report, it should be able to display the details of all the 5 sites that has been selected in a report. These 5 sites need to belong to the same product code and contracter. The problem now is that I do not know how to design a report based on the form.

These are the 3 tables I am having now.
InfoOfSite table ( contains details abt the site)
Project table ( contrains details abt the project)
Contracter table ( contains details abt the contracter)

The relationships are as follows.
Project table is connected to the info of site by the projectcode. The contracter table is linked to infoOfSite table by contracter id.

Someone Please give me some suggestions!! I really need some help urgently!

Thanks