John Clark
John.Clark at niagaracounty.com
Thu Feb 10 14:03:35 CST 2005
I have been whipping up a db to track our routers and switchs, and where they are wired to...eventually, I'd like to print a report that would be a wire map for a given piece of equipment. I've got it working pretty well, but I'd like to add one more thing before unveiling it. I have a form where each record is a separate piece of equipment, and a subform on this form, that will list all ports and where they go. Currently I have to enter 24 records for a 24 port switch and 48 records if it is a 48 port switch. I would like for it to automatically add 24 or 48 records, depending on the value in the numPorts field. I have never done anything like this before, but I am thinking that I will need some sort of FOR or DO WHILE loop that cycles through and INSERTS a record until it reaches the value of numPorts. Is this the gist of it? I really haven't worked with inserting records at all, so if there is anything I should know here, I'd appreciate it. Thanks John W Clark