Jump to content
Sign in to follow this  
Tpaairman

Value list from field problem

Recommended Posts

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?

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.