|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 1st, 2004, 10:09 AM
|
|||
|
|||
Getting started
I have spent alot of time reading and trying to
understand Access and now understand it will be an on- going process. My question is that I wish to set up a database that will track assets (make, model etc.)by employees. The two tables, personnel and assets somehow dosen't seem enough. There are 15-20 items that get reasssigned to different personnel from time to time and I need to be able to track each asset. I know that this is pretty basic and I have spent long hours trying to get it up and running. If someone has some thoughts as to how they would accomplish this it would be greatly appreciated. 
|
|
#2
September 1st, 2004, 10:33 AM
|
|||
|
|||
|
Hi,
You need a third table. tblEmployee EmployeeId ... employee details tblAsset AssetId ... asset details tblAssigned EmployeeId AssetId and if necessary to keep history AssignedDate ----- RelinquishedDate - frmAssigned is then based on tblAssigned HTH Marc wrote in message ... I have spent alot of time reading and trying to understand Access and now understand it will be an on- going process. My question is that I wish to set up a database that will track assets (make, model etc.)by employees. The two tables, personnel and assets somehow dosen't seem enough. There are 15-20 items that get reasssigned to different personnel from time to time and I need to be able to track each asset. I know that this is pretty basic and I have spent long hours trying to get it up and running. If someone has some thoughts as to how they would accomplish this it would be greatly appreciated.
|
|
#3
September 1st, 2004, 01:31 PM
|
|||
|
|||
|
Thanks for the quick response. Is this third table the
linked table in many to many relationship? Thanks again. -----Original Message----- Hi, You need a third table. tblEmployee EmployeeId ... employee details tblAsset AssetId ... asset details tblAssigned EmployeeId AssetId and if necessary to keep history AssignedDate ----- RelinquishedDate - frmAssigned is then based on tblAssigned HTH Marc wrote in message ... I have spent alot of time reading and trying to understand Access and now understand it will be an on- going process. My question is that I wish to set up a database that will track assets (make, model etc.)by employees. The two tables, personnel and assets somehow dosen't seem enough. There are 15-20 items that get reasssigned to different personnel from time to time and I need to be able to track each asset. I know that this is pretty basic and I have spent long hours trying to get it up and running. If someone has some thoughts as to how they would accomplish this it would be greatly appreciated. .
|
|
#4
September 1st, 2004, 03:04 PM
|
|||
|
|||
|
Hi
Yes, the third table is the junction table. tblEmployee - 1 - many tblAssigned records tblAsset - 1 - many tblEmployee records (depending on the dates) Marc wrote in message ... Thanks for the quick response. Is this third table the linked table in many to many relationship? Thanks again. -----Original Message----- Hi, You need a third table. tblEmployee EmployeeId ... employee details tblAsset AssetId ... asset details tblAssigned EmployeeId AssetId and if necessary to keep history AssignedDate ----- RelinquishedDate - frmAssigned is then based on tblAssigned HTH Marc wrote in message ... I have spent alot of time reading and trying to understand Access and now understand it will be an on- going process. My question is that I wish to set up a database that will track assets (make, model etc.)by employees. The two tables, personnel and assets somehow dosen't seem enough. There are 15-20 items that get reasssigned to different personnel from time to time and I need to be able to track each asset. I know that this is pretty basic and I have spent long hours trying to get it up and running. If someone has some thoughts as to how they would accomplish this it would be greatly appreciated. .
|
|
#5
September 1st, 2004, 03:05 PM
|
|||
|
|||
|
yes, it's the linking table. it's the "many" side of a one-to-many
relationship with tblEmployees and a one-to-many relationship with tblAssets. wrote in message ... Thanks for the quick response. Is this third table the linked table in many to many relationship? Thanks again. -----Original Message----- Hi, You need a third table. tblEmployee EmployeeId ... employee details tblAsset AssetId ... asset details tblAssigned EmployeeId AssetId and if necessary to keep history AssignedDate ----- RelinquishedDate - frmAssigned is then based on tblAssigned HTH Marc wrote in message ... I have spent alot of time reading and trying to understand Access and now understand it will be an on- going process. My question is that I wish to set up a database that will track assets (make, model etc.)by employees. The two tables, personnel and assets somehow dosen't seem enough. There are 15-20 items that get reasssigned to different personnel from time to time and I need to be able to track each asset. I know that this is pretty basic and I have spent long hours trying to get it up and running. If someone has some thoughts as to how they would accomplish this it would be greatly appreciated. .
|
|
#6
September 2nd, 2004, 12:22 PM
|
|||
|
|||
|
Marc - thanks again. On this third table, tblAssigned, I
would like to draw names from the tblPersonnel for both the field received from and also assigned to. Showing that the particular asset was transferred. How might I accomplish this. Many thanks -----Original Message----- Hi Yes, the third table is the junction table. tblEmployee - 1 - many tblAssigned records tblAsset - 1 - many tblEmployee records (depending on the dates) Marc wrote in message ... Thanks for the quick response. Is this third table the linked table in many to many relationship? Thanks again. -----Original Message----- Hi, You need a third table. tblEmployee EmployeeId ... employee details tblAsset AssetId ... asset details tblAssigned EmployeeId AssetId and if necessary to keep history AssignedDate ----- RelinquishedDate - frmAssigned is then based on tblAssigned HTH Marc wrote in message ... I have spent alot of time reading and trying to understand Access and now understand it will be an on- going process. My question is that I wish to set up a database that will track assets (make, model etc.)by employees. The two tables, personnel and assets somehow dosen't seem enough. There are 15-20 items that get reasssigned to different personnel from time to time and I need to be able to track each asset. I know that this is pretty basic and I have spent long hours trying to get it up and running. If someone has some thoughts as to how they would accomplish this it would be greatly appreciated. . .
|
|
#7
September 3rd, 2004, 12:18 AM
|
|||
|
|||
|
Hi,
make a form based on tblAssigned. Add a combobox based on tblPersonnel, with tblAssigned.EmployeeId as the source - the wizard should guide you through this fine. If you need more assistance, please post the approx table structure. Thanks Marc wrote in message ... Marc - thanks again. On this third table, tblAssigned, I would like to draw names from the tblPersonnel for both the field received from and also assigned to. Showing that the particular asset was transferred. How might I accomplish this. Many thanks -----Original Message----- Hi Yes, the third table is the junction table. tblEmployee - 1 - many tblAssigned records tblAsset - 1 - many tblEmployee records (depending on the dates) Marc wrote in message ... Thanks for the quick response. Is this third table the linked table in many to many relationship? Thanks again. -----Original Message----- Hi, You need a third table. tblEmployee EmployeeId ... employee details tblAsset AssetId ... asset details tblAssigned EmployeeId AssetId and if necessary to keep history AssignedDate ----- RelinquishedDate - frmAssigned is then based on tblAssigned HTH Marc wrote in message ... I have spent alot of time reading and trying to understand Access and now understand it will be an on- going process. My question is that I wish to set up a database that will track assets (make, model etc.)by employees. The two tables, personnel and assets somehow dosen't seem enough. There are 15-20 items that get reasssigned to different personnel from time to time and I need to be able to track each asset. I know that this is pretty basic and I have spent long hours trying to get it up and running. If someone has some thoughts as to how they would accomplish this it would be greatly appreciated. . .
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Getting Started Menu | Marty | General Discussion | 2 | August 17th, 2004 05:32 AM |
| Outlook Express could not be started because MSOE>DLL could not be loaded. | Deborah Provins | Outlook Express | 2 | July 9th, 2004 04:00 AM |
| Outlook Express could not be started | Flora | Outlook Express | 1 | June 7th, 2004 07:19 PM |
| How remove Getting Started toolbar | dOinK | Setup, Installing & Configuration | 2 | May 11th, 2004 07:28 PM |
Linear Mode
