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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

save a dlooked up text box value of a form into table 1
unbound text box on form equal to value of column in drop down lis 1
Calculating a text box 9
Search through a table using multiple Criteria from a Form 1
Create two entries in a table with one entry in a form. 1
Populate text boxes and update table 4
Auto filling fields in a sub-form (Access 2003) 1
Updating a table from a textbox on a form 1

Top