Linking two fields one to each other

[arielapellini]

Hello guys,

I have two fields, “Product ID” and “Description” from a Product table that I’m using in a Order Detailed form to create an order for a bunch of products and I want autocomplete one of them when I select the other one. I mean, select the product by searching the ID or the Description of a particular product in dropdown list and filling the other one automatically after selecting the first one.

Looking forward to receive some help from you guys.

Best,
Ariela!!