Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Assigning data to a readonly subform

0 views
Skip to first unread message

Tasmania

unread,
Nov 16, 2007, 10:54:01 AM11/16/07
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
0 new messages