odo Posted April 30, 2006 Share Posted April 30, 2006 I'm creating a database that uses a value list from a table. The user is allowed to add and remove values from this table. I have a checkbox that toggles an "Active" boolean for that entry. This Value List/database table is used for data entry later in another section of the database as a drop-down list. How do I get this drop-down value list to display only the values that are boolean "Active" as described above? I've tried a self-referencing as described in the FMP help, by adding a second boolean field that is automatically filled with a "1". No luck so far. Link to comment Share on other sites More sharing options...
comment Posted April 30, 2006 Share Posted April 30, 2006 In your Values table, define a calculation field (result is Text) = Case ( Active ; Value ) Then base your value list on this field instead. Alternatively, define a relationship from the table where you intend to use the value list to the Values table as: SomeTable::const1 = Values::Active where const1 is a calculation field (result is Number) = 1 Then define the value list to use values from field Values::Value, including only related values starting from SomeTable. Link to comment Share on other sites More sharing options...
odo Posted May 1, 2006 Author Share Posted May 1, 2006 Oh, wow, thank you! So simple, too. : : Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6570 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