Hi Everyone,
So this is my first project with access, and I was wondering if I could get some advice/direction with the project. I was asked to create a new database for an office of about 100 people (all information has already been collected). The database consists of the following information, which I have broken up into separate tables.
-Wires_TBL: Every office/cubicle has a Ethernet wall port which is specific to that location. I am using this as the piece of information that ties everything else together
-Users_TBL: Every user in the office and their personal information
-Desktops_TBL: Every desktop and their respective serial number, hardware info, etc
-Monitors_TBL: Every monitor and its information
-Phones_TBL: Every phone and its information
-Printers_TBL: Every Printer and its information
Here is how they tie together:
-The printers are for the most part independent from the other information, some users have their own printers, but this information is on the bottom of my priority list
-Every Wire/Ethernet Port has a User, Desktop, Monitor, and Phone attributed to it. Simple, but here is where I run into my problem, each "workspace" has 2-3 monitors and 1-2 phones. I am having a lot of trouble correctly linking the information to accomplish the following:
-Display all attributed information for a given Wire, including all the monitors and phones for that workspace. (Mostly solved, I figured out how to do this with a many-to-many and a subform)
-Enter new data for each form separately so the individual tables can be linked later. For example, I add a new User, 3 Desktops, and 5 Monitors (I know how to accomplish this part with a entry form based off of each table). I would then like to assign the new User to an ex-employees Wire Number, leave the New User with a the old users Phone, assign him one of the new Desktops and 2 new Monitors. Is this doable? and if so can someone point me in the right direction? I am very lost as to what to do.
Here is how I set up my relationships.
-Users (userID_PK) :1toMany: Wires (userID_FK)
-Desktop (PCserial_PK) :1toMany: Wires (PCserial_FK)
-Monitors (monitorID_PK) :ManytoMany: Wires (wire number_PK)
-Phones (MACadress_PK) :ManytoMany: Wires (wire number_PK)
So this is my first project with access, and I was wondering if I could get some advice/direction with the project. I was asked to create a new database for an office of about 100 people (all information has already been collected). The database consists of the following information, which I have broken up into separate tables.
-Wires_TBL: Every office/cubicle has a Ethernet wall port which is specific to that location. I am using this as the piece of information that ties everything else together
-Users_TBL: Every user in the office and their personal information
-Desktops_TBL: Every desktop and their respective serial number, hardware info, etc
-Monitors_TBL: Every monitor and its information
-Phones_TBL: Every phone and its information
-Printers_TBL: Every Printer and its information
Here is how they tie together:
-The printers are for the most part independent from the other information, some users have their own printers, but this information is on the bottom of my priority list
-Every Wire/Ethernet Port has a User, Desktop, Monitor, and Phone attributed to it. Simple, but here is where I run into my problem, each "workspace" has 2-3 monitors and 1-2 phones. I am having a lot of trouble correctly linking the information to accomplish the following:
-Display all attributed information for a given Wire, including all the monitors and phones for that workspace. (Mostly solved, I figured out how to do this with a many-to-many and a subform)
-Enter new data for each form separately so the individual tables can be linked later. For example, I add a new User, 3 Desktops, and 5 Monitors (I know how to accomplish this part with a entry form based off of each table). I would then like to assign the new User to an ex-employees Wire Number, leave the New User with a the old users Phone, assign him one of the new Desktops and 2 new Monitors. Is this doable? and if so can someone point me in the right direction? I am very lost as to what to do.
Here is how I set up my relationships.
-Users (userID_PK) :1toMany: Wires (userID_FK)
-Desktop (PCserial_PK) :1toMany: Wires (PCserial_FK)
-Monitors (monitorID_PK) :ManytoMany: Wires (wire number_PK)
-Phones (MACadress_PK) :ManytoMany: Wires (wire number_PK)