angelleye Posted October 1, 2006 Share Posted October 1, 2006 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! Link to comment Share on other sites More sharing options...
Wim Decorte Posted October 4, 2006 Share Posted October 4, 2006 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. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6421 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