March 1, 200817 yr Newbies Hi, I'm pretty new to all this. I've started a database based on a time billing template. I want to add a checkbox for "billed". I've added a text field and set field format to checkbox with value list (empty) or X. The checkbox works, in that I can "check" it. But I want everything checked as "billed" to dissapear from my view, a template form called "billing items". Any help is appreciated. PS, the help file won't launch for some reason. I know it's old software.
March 2, 200817 yr First of all, rather than a value list of "x" you should use a value list of "1" (the number one). It will make it easier later on to use the field in calculations. You can do a Find for your checkbox and omit the billed records. Or are you talking about a portal or something?
March 10, 200817 yr Author Newbies Thanks for your reply. "1" is fine instead of "X". I know I can filter the shown records using find, but is there a way to alway have a particular layout filter out certain criteria? I do this in other database programs, they call it a filter. Do you setup a script for a given layout? It seems there must be something simple I'm missing. A simple illustration is a "to do" list of items with a "complete" checkbox. When you finish an item, you check complete and it dissapears off the list. I do this with Outlook tasks.
Create an account or sign in to comment