I am currently working with a database which performs a crossover from a competitor part number to our part number. The current process is:
1)Chooses the competitor name from a drop down
2)Chooses the competitor part number from a secondary drop down
3)Our part number shows up in a protected text box which matches the specific part.
My question is... My supervisor wants me to have the ability to have a form field where I can type out a few part numbers, and then I click a button and it returns the crossover parts according to the competitor parts listed in the form. Is this possible in Access 2007? What are your general thoughts about this? I appreciate any help and opinions.
Thanks,
Bradley
1)Chooses the competitor name from a drop down
2)Chooses the competitor part number from a secondary drop down
3)Our part number shows up in a protected text box which matches the specific part.
My question is... My supervisor wants me to have the ability to have a form field where I can type out a few part numbers, and then I click a button and it returns the crossover parts according to the competitor parts listed in the form. Is this possible in Access 2007? What are your general thoughts about this? I appreciate any help and opinions.
Thanks,
Bradley