Jump to content

If Empty


This topic is 6513 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

In a order entry file I have lookups set to the stock number field.

If their is no match I would like for the lookup file to open and go to the nearest match and allow me to either copy and past it back to the org. file or enter a new number.

thanks

Version: v6.x

Platform: Windows 2000

Link to comment
Share on other sites

HI,

Keep in mind a lookup is based on a Relationship, which must match exactly for the lookup to take place. Maybe one of the gurus here can help. The only thing I can think of is to categorize your stock using another field. Then join the stock# field and the new category field and base your relationship on this new joined field. Then create another relationship based on Category only. At least this way if it does not find a match you can go to related records based on a relationship on the category field only. HTH

Michael

Link to comment
Share on other sites

There is an option in a lookup to get the next highest or the next lowest value. One or the other not the necessarly the nearest. This is handy for some things but I don't think I would use for a stock number.

As an alternate consider a calculated field that produces a list of stock numbers from 10 less than the number entered to 10 higher. Use this as a key to the lookup file stock numbers and display the results in a portal.

Link to comment
Share on other sites

This topic is 6513 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

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.