sbutler Posted February 2, 2005 Share Posted February 2, 2005 Is there any way to look up a value from another table if the Key field is not an exact match? For example, I enter part # J1234 in my quote form. If J1234 does not exist in my pricebook, but J1234A does... can I have it return the lookup data for J1234A? Thanks! -Scott Link to comment Share on other sites More sharing options...
This topic is 6625 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now