Data Form from tables

[k11ngy]

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

 

[Arvin Meyer [MVP]]

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.