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 Chris Miller 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. jrisch

    SQL Table Lookup within a Formula Field

    Thanks, lbass. I was trying to avoid using a subreport as the current record may already be in a subreport. Essentially, I've main records which have a number of audit records each and the audit records have multiple types which are identified in the lookup table. The idea of using an SQL...
  2. jrisch

    SQL Table Lookup within a Formula Field

    Is there a way to interrogate the current database within a formula field? The situation is that I need to obtain a value from a lookup table within the current database, based on a field within my current record. However, I can’t link the lookup table because the field in my current record is...

Part and Inventory Search

Back
Top