Hi! I'm a french literature student trying to understand how to build a database... It's not exactly my cup of tea... so I need a little help:

I'm studying a literary magazine throughout time.

I have 3 tables: [color:blue]authors, [color:blue]articles and [color:blue]issues.

In [color:blue]Issues, there is a field listing the members of the [color:green]editorial committee at the time.

I'd like to have a field in my [color:blue]authors table showing the value of another [color:blue]issues field ([color:green]issue's number) for each record where the author's name is found inside the [color:green]editorial committee field.

For example: if, for the issue #3 of the magazine, the committee value was:

Paul Chamberland

Pierre Maheu

Anre Major

and, for the issue #4 it was

Pierre Maheu

Andre Major

Gerald Godin

I'd like to have a field in Pierre Maheu's record in the [color:blue]authors table showing that he has been in the committee for the 3rd and the 4th issue of the magazine.

But I cannot find how to do that!

...can you help me?

There are several ways to do this. For example, you could define a new relationship between Authors and (another occurrence of) Issues as:

Authors::Name = Issues 2::EditorialCommittee

Then a calculation in the Authors table (result is Text) =

List ( Issues 2::IssueNumber )

will return a list of the relevant issues. Note that this depends on the names matching exactly. It would be better to list the committee members in another table using a unique ID.

Thanks a lot! works like a charm!

You really helped me out!