Hi experts,
I have a table which has some fileds some of the fields is realy based on the selection of others
e.g.
Table Cat11
Day Number
Brand Text textbox value based on bdesc (after update of bdesc)
Bdesc Text combobox lookup table brand
Bage Number
Bsex Number (1)Male (2)Female
Lookuptable for Brand
BRAND
NOT STATED 000001
A & P 000002
A CUT ABOVE 000003
A LA CARTE 000004
A. RICHMAN & SONS000005
A-LINE 000006
A-LINEEVERDES 000007
when a entry operator selects A & P in the desc combo the textbox automatically filled 00002
But the DATA doesn't store in the table..............it only display on the form.
Simply what I did to display / relationship for this two combo box
control source of Brand =[desce]
but this action only display whatever chose in desc that doesn't store in the table
How to I store the brand value which is auto populated by desc.
Any help would be appreciated.