Sorry i dont have an example because i dont know how to do this and haven't found anything regarding this in my various searches I have attached pictures
Name: program.jpg Views: 774 Size: 103.5 KB

what i want to do exactly is if the first column contains the words TP8 then it looks into the Store Number column... From their i want my drop down box to contain all the different store numbers and use the store number as a record selector so it also bring the city, state, etc. to the textboxes...does this kinda clear it up?