consider three tables: concerts, pieces, composers.
a concert has a link column to the pieces table and a piece has a link to the composers table.
if I add a lookup column in the concerts table and set the link field to the piece and the lookup field to composer, the result is "untitled"
