I have an app generated for a database that contains (among others) the following tables; businesses, contacts, contracts. The business table is the master table to the detail tables: contacts and contracts. The businesses are coded with status codes A=advertisers, F=former advertiser, D=defunct, and P=prospect.
In the current app I have a WHERE clause in the businesses table "Edit SQL query" screen excluding the prospects (!='P'). I would like to have another menu item which would include only the prospects (='P'). I would prefer not to have the sales staff creating the sub-set using the search bar. I'm looking for the menu selection equivalent of searching for "Status Equals P".
In all other respects, it would be treated the same as all the other businesses. With the possible exception of eliminating the master-detail relationship to contracts, since they won't have any contracts as long as they remain a prospect.
Is this possible? If so, how might I implement this?
Thanks,
Roy
<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=1659&image=1&table=forumtopics' class='bbc_emoticon' alt=':unsure:' />
