Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. steveh2

    Table design lookups with where clause?

    So I think you agree with me, it can't be done, you cannot have a dynamic parameter query at the table level in the lookup tab that limits the contents of a dropdown, you have to do it at the form level. Steve
  2. steveh2

    Table design lookups with where clause?

    Using the form was not the problem, it was how to do it at the table design level, it can't be done, we've used forms. Steve
  3. steveh2

    Table design lookups with where clause?

    The adresses are the same, a company can have multiple addresses, and employees work at one of them. Ok, it can't be done, no problem there, we'll just use the form wizard then quickly edit that. Thanks for the replies, it's much appreciated, at least I know I'm not going crazy trying to do...
  4. steveh2

    Table design lookups with where clause?

    How do you reference the current row in a where clause on a table design? As an example, let's say we have three tables, company, address and employee: * addresses belong to companies and have a CompanyID * An employee has an AddressID to indicate the address at which they reside and a...

Part and Inventory Search

Back
Top