Hi,
I've designed below form and I've used lookup for Product code and production description.
both these information is available in one table.
is there any option in access that when I choose product code, production description comes to the form automatically.
below is a part of my form...