Access to value lists via ODBC..???

[angelleye]

Is there a way to store value list items in a recordset from a web application? In FileMaker, we have a Products file. Within that file is a field attached to a value list called Categories. This value list contains different categories for products.

I'm trying to create the same list of categories on a web site for browsing but using the SQL SELECT Categories FROM Products doesn't work because there are some products in the DB that have manually typed categories (don't need to be displayed on the site). There are too many that aren't accurate and it makes the list look really stupid and a lot longer than it needs to be.

So, if I could could create the recordset using the value list values that would work.

Any information would be greatly appreciated. Thanks!

[Wim Decorte]

Nope, you'll have to build a table in FM storing just the items you want, or write a SELECT sql query from the table with all the values.

This is one of the benefits of using the XML publishing engine instead of ODBC: you can ask for the items of a value list as long as it's on a layout somewhere.