Hi,
I have a requirement to autopopulate a textbox (DIVISION_CD) based on the value in another textbox(LINE_CD).
A table - DIVISION already exists which contains the 2 columns - LINE_CD and DIVISION_CD. How can I use the DIVISION table as a lookup table to autopopulate the values in the DIVISION_CD textbox based on the matching value in the LINE_CD textbox.
Would somebody know on how to about this ? I have googled regarding this but have not been able to find any solution. Any suggestions would be appreciated.
Thanks,
Paul