Grouped information from another table

Discussion created by Kultgerd on Nov 9, 2015
Latest reply on Nov 10, 2015 by kultgerd


I have posted a question about possibilities of grouped information. The example I've used was about colours. Getting a list of colours of the same table could solved.


But I still have problems to get the result shown in another table.


We are generating InDesign and QuarkXpress catalogues out of FM DBs. The Information is stored in several tables. Product text pool, colour and material ... text pool and also tables for the definition which products shall appear on each double catalogue page.


The step I am talking about is the possibility to translate all colour name text boxes which a are placed near the according picture (shirts in several colours with a single text box for each single colour name). Now it would be great to get listed each colour of the actual double page in original and new language to change it via AppleScript.


If I use the same possibilities as for the calculation in the same table, now of another table I get "?" as the result.


colour table => grouped colour (no problem)

colour table -> output table => "?"


I guess it could have something to do with the timing of the calculation?!


Does anyone have an idea?


We are using FM 11 and Mac. (We still must use it as long as it can not be updated at our customers)