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 Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Comparsion between two different tables

Status
Not open for further replies.

makala

Technical User
Mar 13, 2003
7
US
I have two tables, one Switch table(Table Name dbo_DTS_Switch) that holds all the Switch ports I have(field Name SwitchPort), the second table (Table Name dbo_DTS_Server) holds two fields that contain the switch ports(Field Names Switchport1 and Switchport2) that have been used. What would be the code to compare the one total list to the two used lists and display them in a combobox(SwitchPort) on a form? I really love this site and you all are alot of help. Thanks for any answers and help I can get. Hope you have a wonderful weekend.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top