hlabonte Posted October 1, 2007 Share Posted October 1, 2007 I'm stuck on what I think should be a simple issue. I have a small database (FMP9 adv) in which I want to use a SQL view for a value list. I have my one table defined. I have my one SQL view connected. View contains: id, section, year, term Table contains: student name, request, gender, etc. FMP table has one field "request" in which I would like to display/select from the values from the above view for selection. If I hard code the view data into a value list, I'm good. What I'd like to do is define a value list to pull fields from my view. My SQL view is not selectable when I choose" use values from field". Why is it greyed out? I know I'm missing something simple, but can't figure it out. TIA! Link to comment Share on other sites More sharing options...
Newbies jgraff Posted October 4, 2007 Newbies Share Posted October 4, 2007 hlabonte - Unfortunately it's not something simple. At one of the sessions on ESS this year at DevCon someone asked this exact question and the answer was it's currently not possible. It sounded like it had a good chance of being a feature in an update, but who knows if that will happen. Link to comment Share on other sites More sharing options...
TimD Posted October 29, 2007 Share Posted October 29, 2007 hlabonte -- Depending on your situation, you might be able to load a local FM table with the values from the SQL view first, and then use the FM table as the basis of the value list. You could reload the local table from time to time. This would work if the number of records in the view were relatively low, if the values change infrequently, and so on. -- Tim Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6159 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