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).
Will this work if the corresponding circuit and Patch records are on two different tables. Rack and Patch are on one and Rack and circuit are on another.
I have a delete button on a form. I would like for it to delete the current record and also any corresponding records with this one delete button.
Example:
I want to delete a rack record, when I delete the rack record I also want the corresponding Patch Panel and Circuit records deleted...
#1 Depending on which rack I have selected, I want to calculate how many amps are being used by that particular rack. How would the code go?
The AMPS and Rack Fields are listed in the same table, Need the sum to display in a text box on form that is link to this table. Can someone please...
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...
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...
I have a form that contains a subform. The subform will be used to enter new Switch Ports and Panels into. This data is to be stored in a new table; however, the orginal form is linked to a different table. How do I get the information entered into the subform to the new table?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.