Use a combo box to choose the user all fill in any details that are
necessary (although the StaffID should be sufficient to store. Use a
subform, if there are multiple entries, or use the same form if there's only
a single entry per instance.

There is a wizard that will build the combo box code for you.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"k11ngy" wrote in message
...
Hi, very new to Access, I have project i am stuck on

I have designed 4 tables:

1. Hardware
2. Supplier
3. IT Technicians
4. Staff details

I think I have made correct Primary and foreigh keys as in

Hardware ID, Staff ID, IT Technicians ID and Supplier ID as primary keys
and
foreign keys in relevant tables

I need to make another table that stores fault logs and a user form to
input
this data. I have tried variuous methods, to no real avail.

I want the staff details to be at top so that when user types in the ID
there name and details appear and underneath they can type in what the
exact
fault is they are reporting. I just cannot get the first bit to work and
very unsure on this

Any help would be appreciated

Thanks

Steve