I currently have a database with multiple tables linked by the field "Contact ID." For the sake of discussion, let's assume the tables are as follows: "Contacts" with information such as name, address, phone #, etc.; "Languages" with the languages spoken by each contact; "Countries" with the countries in which each contact has worked; and "Organizations" with the organizations with which each contact has worked. Users currently query the database by putting the desired values in a form. The results are displayed in a form as well. The Contacts, Languages, and Countries are displayed in subforms linked to the main form by Contact ID. My problem is that I can't figure out how to create a report like the one below. Ideally, users would still query the database using the form but would then see their results in the report as opposed to a form. I would greatly appreciate any help.
EXAMPLE OF DESIRED REPORT LAYOUT
ID NAME LANGUAGES COUNTRIES ORGS
1 John Doe French Canada UN
German Paraguay USAID
Italian Sweden
Uraguay
4 Jane Doe Chinese Afghanistan CDC
Japanese England IMF
Romanian Ethiopia UN
Russian
7
.
.
EXAMPLE OF DESIRED REPORT LAYOUT
ID NAME LANGUAGES COUNTRIES ORGS
1 John Doe French Canada UN
German Paraguay USAID
Italian Sweden
Uraguay
4 Jane Doe Chinese Afghanistan CDC
Japanese England IMF
Romanian Ethiopia UN
Russian
7
.
.