Jump to content

Eliminate obsolete products from drop down list


carlosnorvik
 Share

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

Recommended Posts

Hi everybody:

I have a product drop down list that shows all products for a certain supplier when making a new order.

The list changes according to the supplier of the products.

 

This is easily done by indicating who the supplier is in the products Table and making the appropriate relationship.

 

Now, I want to shorten the list by eliminating obsolete products (I need to keep history, so I can't simply delete the obsoletes from the products table)

The products table has a field which I can click when a product becomes obsolete.

 

My solution (it works, but I don't like it) is adding a field called obsolete in the purchase orders table, which is automatically set to "no" and I added a second relationship for the value list, so that if product is obsolete, it is no loger valid via the relationship.

 

Any ideas of a better way to do it?

 

Thanks

Carlos

Link to comment
Share on other sites

Hi Carlos,

 

One option:  In your Products table, create a calculation which inserts the ProductID only if the product is active and then use THAT ProductID in a new value list called Active Products.  The calculation should be indexed.

 

An example calculation in Products could be similar to:

 

If ( not IsObsolete ; ProductID )

 

... where IsObsolete is a number field with a 1.  Adjust as needed to fit your Obsolete field.

  • Like 2
Link to comment
Share on other sites

The calculation will be on the child side and it will be stored (do not set set it to unstored).  So yes, it has a small hit but no more than any other technique and less than most. 

Link to comment
Share on other sites

I suppose because I believe that everything has a cost, no matter how slight.  We work in nanoseconds and pts and the very minuscule and nothing is everything or absolute except uncertainty.   :smile:

 

But the hit would be the initial index, wouldn't it?  Thank you for affirming that it is very negligible.  I mean, nothing is for free, is it?   :laugh2:


Edited ... I should have said that the impact is less than anything else.  LOL.

Link to comment
Share on other sites

This topic is 2842 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.