I have 3 linked table;
Doc (has document details) which has a ref to
Doc_type (for example letter or plot plan) and both these tables have a ref to
Doc_type_group (in example of letter, correspondence and of plot plan, drawing).
In the Doc table, the user first selects the Doc_type_group and then I have used this Valid_if statement on the Doc_type column which works like a treat to show only the related Doc_types.
orderby(select(doc_type[doc_type],[doc_group]=[doc_type_group],false),[doc_type])
So my next step is to have the user select only certain Doc_types that he will use on this particular project (i.e. in this app). I have added a column called Used into Doc_type as a yes/no. I donโt want to delete all the other Doc_types as he may need them in the future, I just want them not to show.
How do I add โanotherโ Select statement to exclude Used=no? My current select statement uses column doc_type (the key) but this wold have to select based on column Used.
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |