Asset Form

[Hopest]

Hi,

I am trying to create an Asset database for IT equipment and would like say
three tables

1) Computers
2) Monitors
3) Staff

I would then like a form for each table allowing to see the different
equipment seperatly and to add to it but when you open the Staff form I would
like it to have under each staff record the equipment the staff member has.

so the staff form would have:

Name:
Team:

Then a list below with what equipment they are using.

How can I do this?

 

[Maarkr]

I would use two tables:

StaffTbl
-StaffID
-FName
-LName
-Phone
other staff fields as needed

EquipmentTbl
-EquipID
-StaffID
-EquipType
-EquipName
-EquipSerial
other equip particulars as needed

Create a relationship between the StaffID in the StaffTbl to StaffiD in the
equipment tbl. Use the EquipType field as a lookup or combo to select the
type of equip: computer, monitor, printer, etc. This makes it easy to
query. One form to enter Staff info, one form as a main form/subform, using
Staff as the main part and Equip as the subform.

 

[Hopest via AccessMonster.com]

Thanks for replying.

Would this setup also allow me to create say a Monitor form and a Computer
form so I can input say a new computer into it and have a quick flick through
just the computers?

I would use two tables:

StaffTbl
-StaffID
-FName
-LName
-Phone
other staff fields as needed

EquipmentTbl
-EquipID
-StaffID
-EquipType
-EquipName
-EquipSerial
other equip particulars as needed

Create a relationship between the StaffID in the StaffTbl to StaffiD in the
equipment tbl. Use the EquipType field as a lookup or combo to select the
type of equip: computer, monitor, printer, etc. This makes it easy to
query. One form to enter Staff info, one form as a main form/subform, using
Staff as the main part and Equip as the subform.

Hi,

[quoted text clipped - 17 lines]

How can I do this?