Tasmania
unread,Nov 16, 2007, 10:54:01 AM11/16/07You do not have permission to delete messages in this group
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to
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.
--
thadi