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!

  • 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. Smacky22

    Need two relationships to a single table

    I've tried this before myself. It will allow me to create the relationship, no problem. However, If I try to run a query that includes airline, It will respond with zero records. I need to be able to run queries to 'see' the airline based on the PurchaserID, OperatorID, or both.
  2. Smacky22

    Need two relationships to a single table

    I have a situation were I have a main table and several additional tables that have relationships based on an ID using an auto-number. Anywhere I have a word followed by ID is a place where a relatiohship exists between two tables using an auto-number. I have one particular table (tblAirline)...

Part and Inventory Search

Back
Top