Form design for tool store database

[V760838]

Hi,

I am designing a tools issue & return database. I am having a table named Technicians with their unique ID and particulars. There is another table for tools with a unique ID and descriptions. Each technician can place an order for many tools from a front-end database in another computer. The tools in-charge then checks the orders and issues the tools by entering a tool serial no and time of issue against the orders. When the tool is returned by the technician ( returning could be in parts or all the tools at a time), the tools in-charge enters the time-in against the toolto complete the transaction.

My problem is that how can I make a form so that the technician can select the tools from the existing table for putting the order without entering his unique ID repeatedly for each of the tool ?

[orange]

BUild a data model to get your initial tables structured and related.

You might wish to watch these free videos, that are available to anyone with access to the internet. There are other videos, these are just a sample.

http://www.youtube.com/watch?v=IiVq8M5DBkk Logical data modeling

http://www.youtube.com/watch?v=BGMwuOtRfqU Candidate key

http://www.youtube.com/watch?v=ZiB-BKCzS_I Normalization

http://www.youtube.com/watch?v=pJ47btpjAhA Normalization example

http://www.youtube.com/watch?v=q3Wg2fZENK0 1st Normal form

http://www.youtube.com/watch?v=vji0pfliHZI 2nd Normal form

http://www.youtube.com/watch?v=HH-QR7t-kMo 3rd Normal form

http://www.youtube.com/watch?v=q1GaaGHHAqM E_R Diagramming

You can go back and watch these as often as you want.