Auto-populating fields in a form

[broush]

We have a form with a list box that allows us to view equipment information
(part #, desc., etc.) When we select a record from this list to enter into
the form, the information is not populated in the table.

Little background information: We have one table that contains equipment
information (inventory). We have a form that we created that is used to
create service tickets if the equipment fails. When we select the equipment
from the list box we want that information to go into the "Service ticket"
table.

 

[John W. Vinson]

We have a form with a list box that allows us to view equipment information
(part #, desc., etc.) When we select a record from this list to enter into
the form, the information is not populated in the table.

Little background information: We have one table that contains equipment
information (inventory). We have a form that we created that is used to
create service tickets if the equipment fails. When we select the equipment
from the list box we want that information to go into the "Service ticket"
table.

ONLY the single unique ID field for the equipment should be copied into the
Service Ticket table. Storing the description, etc. redundantly is almost
certainly neither necessary nor prudent; you can display it on the form or
report by drawing it from the equipment table.