If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Data Form from tables
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 |
#2
|
|||
|
|||
Data Form from tables
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 |
Thread Tools | |
Display Modes | |
|
|