i would like to populate a textbox on a form based on the users selection of a combo box which is also on the form.
the 2 tables concerned are:
table task - the user selects the task using a combobox -
Primary key taskid
field taskdescription - this is the option the user chooses
field procid - this is a foreign keyfield which links to the procedure table
primary key procid
field procedureDescript - contains the proceedure description relating to the task
in a nutshell - if the user selects a task then I would like the textbox to display the related proceedure using the procid.