Aggregate function and tooltip

[tmas73]

Maybe i did not explain it to well the first time here a deeper explanation.

I have a list view and when I roll over the entry with the mouse the tooltip should show a specific listing. Now this Specific Listing consists of 2 fields. Field one:

"Scenes:¶" & List (scenes::Scene Title)

Field two

List (scenes::TC_Duration )

If I would combine the two fields

("Scenes:¶" & List (scenes::Scene Title) & List (scenes::TC_Duration )

The result is way different, it looks like:

Scene:

Scene Title - TC Duration

TC Duration

TC Duration

TC Duration

The Scene Titles are missing after the first listing.

The result should be:

Scene:

Scene Title - TC Duration

Scene Title - TC Duration

Scene Title - TC Duration

Scene Title - TC Duration

how can I combine the to listings to create a view including both fields?

Thanks

TMAS

Edited July 25, 2006 by Guest