S
Stranger
Current flat table (COMPUINV) contains all fields about the computer
inventory including employees, handhelds and printers. the only unique
key in the flat table is the auto number field. this is the primary key.
Everything is in one row.I exported the table structure from the original table. Hopefully it will look correct in here.
ID Site Location UserName ComputerMakeModel SerialNoServiceTag Type SPEED RAM HD WindowsVersion OfficeVersion CD JackNumber PRINTER PCName IPAddress LastUpdate UPSInservice Date Registered HandheldModel HandheldPhoneNumber HandheldSerial Spybot
Well, you kind of see the current setup. It was a terrible design.
What I did was take that table, added some fields and made this:
ID PrinterID EmployeeID ComputerID HandHeldID UPSID SiteID Site Location UserName ComputerMakeModel SerialNoServiceTag Type SPEED RAM HD WindowsVersion OfficeVersion CD JackNumber PRINTER PCName IPAddress LastUpdate UPSInservice Date Registered HandheldModel HandheldPhoneNumber HandheldSerial Spybot
the next part I may not have needed.
This is where I took the current ID and copied it into the corresponding ID field that I made. Lets say that ID 4 had an employee, printer, and computer in that row. I took the ID 4 and put it into the fldempolyeeid, fldprinterid, and fldcomputerid. I hope that makes since. So, If I can run an append query that will take the data from the above ID fields and put them into the tblemphrd in the new table, then everything should be related back together.
Does this help?
inventory including employees, handhelds and printers. the only unique
key in the flat table is the auto number field. this is the primary key.
Everything is in one row.I exported the table structure from the original table. Hopefully it will look correct in here.
ID Site Location UserName ComputerMakeModel SerialNoServiceTag Type SPEED RAM HD WindowsVersion OfficeVersion CD JackNumber PRINTER PCName IPAddress LastUpdate UPSInservice Date Registered HandheldModel HandheldPhoneNumber HandheldSerial Spybot
Well, you kind of see the current setup. It was a terrible design.
What I did was take that table, added some fields and made this:
ID PrinterID EmployeeID ComputerID HandHeldID UPSID SiteID Site Location UserName ComputerMakeModel SerialNoServiceTag Type SPEED RAM HD WindowsVersion OfficeVersion CD JackNumber PRINTER PCName IPAddress LastUpdate UPSInservice Date Registered HandheldModel HandheldPhoneNumber HandheldSerial Spybot
the next part I may not have needed.
This is where I took the current ID and copied it into the corresponding ID field that I made. Lets say that ID 4 had an employee, printer, and computer in that row. I took the ID 4 and put it into the fldempolyeeid, fldprinterid, and fldcomputerid. I hope that makes since. So, If I can run an append query that will take the data from the above ID fields and put them into the tblemphrd in the new table, then everything should be related back together.
Does this help?