>Here's my thought: I have a pricing and availability database/form with 40,000 items. Sales people write a ticket with 10-20 of the items (in its own dbf).
>How can I show the entire database, then users click a check box to toggle to just their 10-20 items?
If you've got that many items, you're never showing all 40,000 of them anyways. One approach is to use 2 dropdown lists, where the first one contains a list of item Groups plus one more value that means "Show my current ticket items". When one of the first dropdown's values is selected, that filters the second's values.
If you have lots of items you might use even 3 or 4 levels of dropdown lists.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up