T
Tasmania
Hi. I am creating a employee computer inventory database. The tables are
Employee, Hardware, Status.
Fields of the tables are-
Employee: EmpID,LastName,FirstName etc.
Hardware: HID, Make, Model, AsseTag, Category, Serial#, AcquiredDate
PurchaseOrder#, EmpID, StatusID etc.
Status: StatusID, Status
Hardware table is already populated with a series of items. A new piece of
hardware purchase goes to the hardware table.
I am using a form to enter hardware data.
When a new Employee comes, I enter the Employee data through a form.
Then I have to assign a piece of hardware to that employee, which will open
the Hardware form, and pick a hardware item for that employee.
The Employee form will have a hardware subform that will show the specific
hardware data assigned to that employee, but this subform is for viewing only.
The hardware Assigned with the specific Serial# will belong to only that
employee.
I am not sure how I can achieve that. I am a novice programmer. I greately
appreciate any help.
Employee, Hardware, Status.
Fields of the tables are-
Employee: EmpID,LastName,FirstName etc.
Hardware: HID, Make, Model, AsseTag, Category, Serial#, AcquiredDate
PurchaseOrder#, EmpID, StatusID etc.
Status: StatusID, Status
Hardware table is already populated with a series of items. A new piece of
hardware purchase goes to the hardware table.
I am using a form to enter hardware data.
When a new Employee comes, I enter the Employee data through a form.
Then I have to assign a piece of hardware to that employee, which will open
the Hardware form, and pick a hardware item for that employee.
The Employee form will have a hardware subform that will show the specific
hardware data assigned to that employee, but this subform is for viewing only.
The hardware Assigned with the specific Serial# will belong to only that
employee.
I am not sure how I can achieve that. I am a novice programmer. I greately
appreciate any help.