On an input form that captures customer information I have a combo box that provides the data selection for field 1. I need field 2 to populate depending on the selection for field 1.
Details:
Field 1 is actually Product Code
Field 2 is actually Product Description
The combo box is based on a table called "Products" and has two columns as follows:
Product Code Product Description
ABC Acronis Backup Cloud
SPLA Service Provider License Agreement
Question: What do I need to do to make the Product Description field auto-populate depending on the Product Code selection using the combo box?
Thank you,
Kurt