Questions on list function

[Bo Wang]

I have two tables here. First one with film titles and dates of different channel I need to sent to. The table structure is basically like

"Title              Channel_1         Channel_2 ...

 film_1             Dec'12              Jan'13      ...

...                                 

 

The second table would be a chart that I want to generate from data of table one, listing each month's due titles to each channel like:

"Month          Channel_1                Channel_2...

 Dec'12         film_1,  film_2 ...

 

I used a x relationship to connect two tables. Each text block on table two will be a list of film names that goes to the channel under the related due month. It seems natural for me to use list function with an embedded case or if function to bring all films with same date into one block, like the Dec'12/Channel_1 block using

 

List ( Case(table one::Channel_1=table two::Month ; table one::Title ; ""))

 

but it doesn't work. Anyone have any suggestions? Might be a rookie question. Big Thanks!

[comment]

The table structure is basically like

"Title              Channel_1         Channel_2 ...

 film_1             Dec'12              Jan'13      ...

...                               

 

This is not a good starting point. You should have one table for the films and another table for the submissions. And probably a third table for the channels:

 

Films -< Submissions >- Channels

 

 

The easy way to produce your report would then be to find all submissions in a given month and sort them by channel.