leadma Posted March 17, 2014 Report Share Posted March 17, 2014 I have a table "Product"; Product_id (autonumber) Product_name (text) Product_valid (yes/now) I an different table, i have a lookup Field to table "Product" I only want the user to be able to select records where I have marked "yes" in the checkbox? Do I have to create a own view, or is it at better way? Quote Link to comment Share on other sites More sharing options...
0 MayMusic Posted March 17, 2014 Report Share Posted March 17, 2014 Create a view based on this table to pull up the records where this checkbox is checked and use this view as lookup instead: http://howto.caspio.com/tables-and-views/what-are-views/creating-a-view-to-filter-data/ Quote Link to comment Share on other sites More sharing options...
Question
leadma
I have a table "Product";
Product_id (autonumber)
Product_name (text)
Product_valid (yes/now)
I an different table, i have a lookup Field to table "Product"
I only want the user to be able to select records where I have marked "yes" in the checkbox?
Do I have to create a own view, or is it at better way?
Link to comment
Share on other sites
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.