Comparsion between two different tables

[makala]

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 the ports that are still available in a combobox(SwitchPort)on a form(Network Information)? 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.

 

[SBendBuckeye]

Select dbo_DTS_Switch.SwitchPort
From dbo_DTS_Switch
Where dbo_DTS_Switch.SwitchPort Not In
(Select dbo_DTS_Server.SwitchPort1
From dbo_DTS_Server)
And dbo_DTS_Switch.SwitchPort Not In
(Select dbo_DTS_Server.SwitchPort2
From dbo_DTS_Server)
Order By dbo_DTS_Switch.SwitchPort

Good LucK!

 

[makala]

OK, The above comparsion will be based on which Switch Panel(SwitchPanel field on the Network Form on the dbo_DTS_Server Table) has been selected on the form (Network Information)in a combo box (Switch Panel).