1) in design view, select the list, in the property inspector, click the dynamic button.
for the select item equal to option, click the lightning bolt and select the corresponding category column from the update recordset.
2) Use data assist search to set this up.