copy a text value of a form into table

A

Azad, DH, BD

I have a entry form where I have a combo box to select material code. After
selecting material code from combo, other two text boxes will show material
name and unit that are dlooked up from item table. Now I 'd like to save
these two text boxes with other entries to a nother table called Product
details.


Pls help me.

Thank u all genious bosses for your kind help in advance.
 
B

Beetle

It's unnecessary and redundant to store those attributes in more than
one table. The only value you need to store is the PK value of the item
(or material). The other attributes can be retrieved whenever you need
them by using a query, DLookup, combo box, etc.
 
Top