Here is my problem it seems as if it should be easy, but I haven’t been able to figure it out:
I have two tables, and a link table between them. It is a one to many relationship. I try to display them in a report, but it shows the data on different lines, and I need it together on one line.
To clarify, this is the details of it:
Table RadioStations
one column radioStations
one column ID
table location
one column cities
one column city ID.
a link table
linking the cityID with the RadioStationID.
There can be up to five radio stations per city and I need it displayed something similar to this:
Toronto: CKNW / CKKK / CFPL etc.
If anyone could help me I would be very appreciative, since I need to have this project completed before the weekend and I have no idea how I am going to do it.
I have two tables, and a link table between them. It is a one to many relationship. I try to display them in a report, but it shows the data on different lines, and I need it together on one line.
To clarify, this is the details of it:
Table RadioStations
one column radioStations
one column ID
table location
one column cities
one column city ID.
a link table
linking the cityID with the RadioStationID.
There can be up to five radio stations per city and I need it displayed something similar to this:
Toronto: CKNW / CKKK / CFPL etc.
If anyone could help me I would be very appreciative, since I need to have this project completed before the weekend and I have no idea how I am going to do it.
