3 Replies Latest reply on May 13, 2011 2:48 PM by philmodjunk






      I have a table that has suppliers on my database - I can make a supplier active or inactive by a radio button.

      Now when I am in another table entering an order I get a list of the suppliers that provide that product so that I can choose from a drop down the supplier -  Currently it shows me the list of all the suppliers allocated to that product whether active or inactive.

      The question is, how to I make it so that on the drop down only shows me active suppliers?

      Thanks in advance




        • 1. Re: Active/Inactive

          What you describe is called a conditional value list. The following tutorial describes two different ways to implement what you want. The first option is simpler to set up, but less flexible than the second option:

          Custom Value List?

          • 2. Re: Active/Inactive

            Hi Phil,

            I do have a conditional value list already that allows me to choose the suppliers that are allocated to the product in question.

            My question is that some of this suppliers are inactive and I dont want them showing on my custom value list, so even though they are allocated to the product beacuse they are inactive they should not show on the drop down.

            Can you help?


            • 3. Re: Active/Inactive

              You can either modify the relationship so that only "active" supplier records are related (Option 2) or you can define a calculation field in the supplier table that only returns a value when the radio button field = "Active" and refer to it in your value list definition (Option 1).

              Define this relationship (option 2);

              Orders::ProductID = Suppliers::ProductID AND
              Orders::constActive = Suppliers::Status

              constActive is a calculation field that simply returns the quoted text: "Active".

              Status would be your radio button field where you designate a supplier as "active" or "inactive".