Value list from field problem

[Tpaairman]

My FMP file is connected to on online store shopping cart that I have, which is a MySQL DB. One of the MySQL tables is the category names, and I'm trying to use the name field there for a value list in Filemaker. But of coarse I can't pick that table.

There are two category tables on the MySQL side - the categories, and the category names (the first is the main table, the names are separate to allow for other languages - long story, don't ask) anyway, I have join table in FMP for these two, and a calculation field that equals the category name (plus dashes if it's not a top level category.) And that calculation field is what I would like to use for the value list, but it can't be indexed. So how might I be able to go about this?

[IdealData]

I did some testing with SQL and ESS a little while ago, but I'm no expert.

Why can't you pick from the SQL table if you have it represented as a TO in your FM file?

[Tpaairman]

All of the MySQL tables are grayed out when I go to select which table. I can only pick a table that is within the FMP file.