Jump to content

SQL view for value list?


This topic is 6082 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

  • Newbies

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

  • 4 weeks later...

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

This topic is 6082 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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