Ok, here's what I want to do. I have 2 fields on a form. The first one is Prodnumber the next field is Prodname.
I want to be able to paste this whole string -->QL51578 (BEER FLAVOR MIXTURE (QL34589 NAARDEN)) into the first field, then upon refreshing or saving, I want this part of the string -->BEER FLAVOR MIXTURE to drop down to the second field. So in the end the first field would contain: QL51578 and the second field would contain:
BEER FLAVOR MIXTURE.
Yes, I want the rest of the string besides the product number to disappear in the first field upon refreshing or saving. Does that make sense?