Not sure if I have the correct group here, or even if I am using the proper
language to explain what I want to do.

I need to use Excel (or Access or Works) to create a linkable product order
form. This needs to be able to go to the database I create, search for the
item # I input and then return to the next 3 columns in the row I am in the
values that go along with that item # in the database. (ie: 170113 would be
the item # and the next 3 columns would say 12 oz. Cranberry Juice
Concentrate, OG 3.75