I'm weak on calc knowledge, but here's my goal. I want to display related field data in a tooltip as a hard returned list.

The tooltip is formatted on the Partnum field in LiveJobs. I want to show all related historical partnums and thier release dates. I currently have data from the first related record showing in the tooltip:

History::Partnum & " " & History::ReleaseDate

How can I make the tooltip calc display data from those 2 fields in a hard returned list from ALL related records? TIA.

1) Make a calc field called "TooltipCalc" on the history table:

History::Partnum & " " & History::ReleaseDate

2) Make your tooltip display:

list ( History::TooltipCalc )

J

Thanks, James. I built the TooltipCalc field in the History table, but I still only get calc result from the first related History record.

I'm not understanding your reference to "list". That is not a function. I think I may need to use the Substitute function in order form a list? Would that be correct?

Thank you for the help. I know I'm very close to making this work.

List () is a function as of 8.5. With 8 you can use a value list and then use ValueListItems ()

We're planning an upgrade to 11 sometime this year. Looks like this may be easier in newer versions. I created the value list; HistoryPartNum; in the LiveJobs file:

From Field

Fields: "LJ_History ItemID::part#" and "LJ_Hisotry ItemID::Release Date" (related values only)

Values show up correctly in drop down list in LiveJobs. However, when I try to specify the tooltip with

ValueListItems (LiveJobs; HistoryPartNum)

I get error "Specified table cannot be found"

Why does it ask for a table when the function asks for fileName? I tried using LJ_History ItemID table name but got the same error.

I'm probably not explaning enough or missing something, obviously. Thanks, John, for your help.

You should still make your tooltip calc.

History::Partnum & " " & History::ReleaseDate

Try that first.

That's where I started. I can get the partnum and date to show in the tootip from the first related record, but it does not return a list of all related partnums and dates.

My tooltip is in LiveJobs file. A separate History file (not table in LiveJobs) holds the related records with data (partnum and releasedate).

Records in History.fp7 file are related to LiveJobs.fp7 file by ItemID (a LiveJobs serial number). That relationship is called LJ_History ItemID. I know this isn't the best database design. It's like an old house - additional wings have been added on over the years.

Sorry to be so dense, but I'm just not understanding why I can't get a list of related num/dates.

I am not sure what the problem is.

Here is a quick example.

LiveJobs.zip

Thank you very much, John. I had it working except the release date wasn't showing up. Your example will help to refine it.

I really appreciate your sticking with me on this. I can see a lot of potentiall for applications of this solution.

It's late and I don't have FM Advanced on this computer, so I'm going home now. I'll work on this next week and let you know how it goes.

Take care,

Dick

John,

Got it working now. Sometimes it's the simplest thing, i.e. not realizing my calc field should have text result (not number) and indexing as needed.

My job requires alternating use of brain hemispheres (mostly graphic art/sometimes FM dev). This sometimes causes confusion in both. At least that's my excuse and I'm sticking with it.

You've been very generous and a great help.

Thanks,

Dick