1 Reply Latest reply on Oct 13, 2009 8:57 AM by philmodjunk

    Check box relationship

    squiggle

      Title

      Check box relationship

      Post

      I have a database that contains toy stores I sell to and don't sell to. I sell 10 different products. Some stores buy 2 product and others buy 8 products. I created a simple check box set of these 10 products so when a store purchases any of these products, I simply check the box next to the product(s). It's really simple and works well so when I'm on the phone with them I know quickly what they have purchased in the past.

       

      What I am try to do is this:

      I created another check box field that says "Customer" which sits right next to the store name. I currently have to manually click the customer check box to let me know they are a customer. This way, when I go to XYZ Toy Store at another time, I can see that they are a customer. Basically, I would like an X to automatically appear next to the name of the store when any of the 10 products are checked off. Here is an image as I am more visual than descriptive. http://www.flickr.com/photos/39221961@N08/4000134305/

       

      I then can search all of my customers.

       

      Thank you for any advice!

        • 1. Re: Check box relationship
          philmodjunk
            

          A simple calculation field will do this for you.

           

          Define a value list for your check box field. Let's simply enter "Customer" as its single custom value.

          Define a calculation field set to return text:

           

          If ( not Isempty (YourProductCheckBoxField), "Customer" ; "" )

           

          Place this field on your layout and use Field/Control | Setup... to format it as a check box field and specify the above value list.