I have a laptop inventory. I would like to make a form that displays the available laptops which are stored in a table and the employees which are stored in another table. I would like to be able to click on an employee and then a laptop and assign the laptop to the employee by copying the data from one table to the other and unchecking the "available" box on the laptop inventory table. Any suggestions...
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Access Move records
- Thread starter danofre
- Start date
Create 3 tables
One has employees
EmpID Name
123 Bob
345 Sam
One has laptops
LaptopID type Available
987 toshiba NO
767 HP Yes
209 Compaq NO
3rd which has employee has what laptop and date and time
EmpID LaptopID Date Time
123 987 7/13/01 16:54
345 209 7/12/01 8:35
Next add another field to the laptop table that is "Yes"/"NO" As shown above "Available" = NO if some one has it or Yes if its avaiable then when you assign an employee to the laptop it also write a NO in the laptop table.
PS you need BARCODES to help you track them.
If they take a laptop, scan their EmpID barcode and LaptopID barcode and it will create the record and add Date and time and add "NO" to laptop Table.
DougP, MCP
Visit my WEB site to see how Bar-codes can help you be more productive
One has employees
EmpID Name
123 Bob
345 Sam
One has laptops
LaptopID type Available
987 toshiba NO
767 HP Yes
209 Compaq NO
3rd which has employee has what laptop and date and time
EmpID LaptopID Date Time
123 987 7/13/01 16:54
345 209 7/12/01 8:35
Next add another field to the laptop table that is "Yes"/"NO" As shown above "Available" = NO if some one has it or Yes if its avaiable then when you assign an employee to the laptop it also write a NO in the laptop table.
PS you need BARCODES to help you track them.
If they take a laptop, scan their EmpID barcode and LaptopID barcode and it will create the record and add Date and time and add "NO" to laptop Table.
DougP, MCP
Visit my WEB site to see how Bar-codes can help you be more productive
- Status