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 TouchToneTommy 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: *

  • Users: dug2k
  • Content: Threads
  • Order by date
  1. dug2k

    2 primary keys??

    Hi, I have a table with the following fields: ResourceID ResourceName DateTime InstructorID LocationID Misc I have 2 different combinations that need to be unique: DateTime & InstructorID, and DateTime & LocationID. I was going to make a combo key of DateTime, InstructorID, and LocationID...
  2. dug2k

    Using query to populate combo box

    I am trying to use a combo box to show a list of values from a table where the SysID is the same as the IDCode of a different table (of the record currently being displayed). What is the best way to do this? I tried using the following query: SELECT Table2.Description FROM Table2 WHERE...

Part and Inventory Search

Back
Top