collecting 2 peices of information from a combo box (1 Viewer)

[steve111]

hi,

I have 2 tables
1. stocklist
2 product details

I created a form called " product details "

using a combo box in the form "product details" I select a "part number " of which the part number and the associated description of the part comes into a fields called "part number " and "part description "
The part number selected then goes into a table called product details
is it possible that when I select the part number , both the part number and the part description go into the table called product details

thank
steve

 

[Keith Tedbury]

Are you selecting the part from a existing stored list of parts then. If it is information already stored in the database then it would be better to just store the ID field in the other table and use that link to the information when you need it rather then copying all the information across.