Tpaairman Posted May 18, 2009 Share Posted May 18, 2009 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? Link to comment Share on other sites More sharing options...
IdealData Posted May 18, 2009 Share Posted May 18, 2009 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? Link to comment Share on other sites More sharing options...
Tpaairman Posted May 18, 2009 Author Share Posted May 18, 2009 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. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5458 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now