Okay, right now the information is being gathered from query, "customersExtended" the idea is this:
Customer A is on equipment LET-01-02-03 and is fed on cable pair 2
Customer B is no longer a customer but was on LET-02-05-04 Pair 4
Customer A's equipment goes south and needs to be moved to old customer B's equipment. We can move them but don't want to lose track of where B's cable pair 4 is going so we want to retain that data. Furthermore, Customer A's equipment will eventally be repaired so we want to maintain that data as well.
I'm very new (three weeks) to access and am trying to grasp the concept of your idea. If I create another table, or two tables, how will all of my information be stored on the primary "customers" table?
Is there no way of doing this with a single table without having to manually enter the table to make the changes? *not a bad option from where I am right now*
Thanks again for your help and your anticipated response!