1 2 Previous Next 22 Replies Latest reply on Jun 27, 2016 7:33 AM by ucharles

    Conditional or dynamic value list?

    bburdeen

      Title

      Conditional or dynamic value list?

      Post

      Still new to FMP... Not sure if I'm looking for a conditional value list or a dynamic value list or maybe something completely different.

      How can I create a dynamic dropdown list that shows numbers 1 to 133 and updates with each new record, not showing the numbers that were previously used.

      Example:
      User1 adds a new record. With this record User1 enters miscellaneous information and then selects number 5 from a dropdown list. Done.

      User2 adds a new record. With this record User2 enters miscellaneous information and then selects number 4 or 6 since number 5 was previously selected by User1 it is not even available from the dropdown list.

        • 1. Re: Conditional or dynamic value list?
          philmodjunk

          This is called a diminishing or dwindling value list and is a special type of conditional value list.

          You can find a working example of such a value list in "Adventures in FileMaking #1 - Conditional Value Lists".

          • 2. Re: Conditional or dynamic value list?
            bburdeen

            Ah. Perfect. Thank you!
            Hopefully I can figure out how to apply this to my solution.

            • 3. Re: Conditional or dynamic value list?
              bburdeen

              Phil,
              I think I have this working the way I want except that the selected items in the dwindling list are reset with a new record. I'd like to have this carry through from record to record. Is that possible?

              I looked at your example and it looks like that's what you have accomplished - I just can't dissect it well enough to understand. I found some other examples out there that have helped me... Being a newbie I'm feeling like this is a little over my head.

              I attached a picture so you can see what's going on, if this helps.

              • 4. Re: Conditional or dynamic value list?
                philmodjunk

                But a screen shot of what you get doesn't tell me exactly how you set it up. What relationships, calculation fields did you set up for this?

                As you have noted, this "dwindling" can be set up to run from the context of the layout's current record, or it might also be set up to work from the context of all records in the table or even a specified sub set.

                And the key (pun) detail will be how you set up your relationships in order to generate the list of previously selected values so that you can exclude them from your conditional value list.

                • 5. Re: Conditional or dynamic value list?
                  bburdeen

                  You hit the nail on the head. I'm looking to make this work from the context of all records.

                  This is what I have (and hopefully I've included everything).

                  I have 3 tables.
                  "Baseball2015" table is for the main records and has an "ID" (Number) and a "List_Seats" (Text) field.
                  "Seats_Lis"t table has an "ID" (Number) and a "Name" (Text) field. This table has the list that I'm using as the dwindling selection list.
                  The 3rd table is "Join_Baseball_Seats" which has 3 fields; "ID" (Number), "Join_IdFk" (Number) and "Name_IdFk" (Number).

                  See the picture for the relation ships. The connection between Baseball2015 and Seats_Available is using the not equal relationship. See picture for that, too.

                  I have 2 value lists.
                  "Seats" which is using values from "Seats_List" (ID) and displaying "Seats_List" Name, including related values starting from the "Baseball2015" table.
                  The "Seats_Available" value list is using values from "Seats_Available" (ID) and displaying "Seats_Available" Name, including related values starting from the "Baseball2015" table.

                  I messed around a little w/the scripts... Currently I have the Refresh and Delete. See pics.

                  What else can I provide you that I may be missing?

                  • 6. Re: Conditional or dynamic value list?
                    bburdeen



                    <img alt="" src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAABC8AAAIQCAIAAAAuL9MoAAAYSmlDQ1BJQ0MgUHJvZmlsZQAAWAmtWWdUFM3S7tkELMuSc85JMkuUnHPOCCw554xKFAkqgoAioIIKggomgogJQUQRQQUMiAQDSQUVFAH5ejG877nn3n/fnjMzz1RX1zxV1d0zXQsAN4EcHR2OYgAgIjI+1t5EX8DVzV2A6jXAAgxgBCigTPaLi9aztbUE//O3MgIQSuMTGYqt/6n23xsY/QPi/ABAbGGzr3+cXwTEVwDAEP2iY+MBwHZDuXBSfDQFz0DMEgsJQrxOwUFbGAfZAxbfX1hkS8fR3gAAnBoA1AQyOTYIAKIhlAsk+gVBO0R/2MYU6R8SCbslQ6ztF0yGMq52qLMtIiKKgt9ALOH7LztB/8Jksu9fm2Ry0F/8yxfYEz7YMCQuOpycsnXz/3mKCE+A8dr6CcIzITjW1B5eWWDcqsKiLCiYAPGFSF9rG4iZIO4MgR79xgPBCaZOEFP0J/ziDGAsARvEX/3JhhYQ8wCAwieEOen9xmLkWIi29FH6IfFmjr+xc2yU/W/7qNDIcGvK+IB2UDuDA8z+4JKAOCMHKIccUKGBIcZmEMNcoc6kBju6QAx5otoTQ5ytISZC3B0X5kDhQLHzODXYgCLf0olNsKdwFoHymcBYY4qPUAdNiIiDaMs+WsiPvPUsDihXjg92NIVy2Bdt6R9gaAQxfC7aNSDS6TcfdHB0vD7FDkU/NTp8a3xDnuiSgHATilwI4lNxiQ5/+t6Nj3WkyGHc0COhZHPKeIWc0XPR8baUmFD4fAeWwAAYAgGQAA9fEAVCQcjAQtsCvPvVYgzIIBYEgQAg81vyp4fLVkskPDuAVPABREKduL/99LdaA0AilG/8lf7qKwMCt1oTt3qEgXfwCREYLow2RhNjCc+68FDEqGHU//QToP/DE2eEM8SZ4oxxkn8kwA+yDodHLAj5LzIL2BYAvYuF58g/PvxjD/sOO4Sdwg5jJ7DPgTN4s2Xlt6feIVmxfxj8tWwFJqC1X1EJgBGLBLN/dDBikDUJo4/RgvwhdwwbhgvIYJShJ3oYHegbCUr/RI/COuEvt39i+Sfuf/QorAX+5eNvOVGKSPrNwvePVzCTfyLxn1b+aQkB/lDL4j810Xnoy+he9G10H7oT3QYE0DfR7eh+9HUK/s3ZeCs6QX+fZr8V0TDoQ8gfHfmz8rPy63/u/vpKhhIKA0oO4PiPD0iOh+MPGERFp8SGBAXHC+jBVThAwCzST3abgKK8AgkAyppO0QHgi/3WWo2wPfpHFgDX1e1wftAM/iMLPQRAYw8A7AX/yMQ8AODcBsDFx34JsYm/7GEoFyzAA3o4MzgBHxAGEtAnRaACNIEuMALmwAY4AjfgBaMeDCIg6ySwE2SCXFAIDoIycBQcByfBGXAeXAJtoBPcBnfBAzAIhsFLODbegnmwCFbAGoIgVAgdwoxwIvyIKCKNKCJqiDZihFgi9ogb4oMEIZFIArITyUYKkRLkKFKDNCAXkavIbaQPGUKeI5PILPIZ+YFCowgoFhQvSgwlh1JD6aEsUI6oHaggVAwqFZWDOoA6gqpFnUO1om6jHqCGUROoedQyGqBp0WxoQbQMWg1tgLZBu6MD0bHo3egCdDm6Ft2E7oC5foKeQC+gVzE4DDNGACMDx6cpxgnjh4nB7MbswxzFnMG0YroxTzCTmEXMTywdlgcrjdXAmmFdsUHYJGwuthxbh23B9sC58xa7gsPh2HDiOFU4N91wobg03D5cNa4Zdws3hJvGLVNRUXFSSVNpUdlQkaniqXKpKqjOUd2kekz1luo7NS01P7UitTG1O3UkdRZ1OXUj9Q3qx9TvqddoGGhEaTRobGj8aVJoimhO0XTQPKJ5S7OGZ8SL47XwjvhQfCb+CL4J34Mfw3+hpaUVolWntaMNoc2gPUJ7gfYe7STtKoGJIEUwIHgSEggHCPWEW4TnhC90dHRidLp07nTxdAfoGuju0I3TfScyE2WJZkR/YjqxkthKfEz8SE9DL0qvR+9Fn0pfTn+Z/hH9AgMNgxiDAQOZYTdDJcNVhlGGZUZmRgVGG8YIxn2MjYx9jDNMVExiTEZM/kw5TCeZ7jBNM6OZhZkNmP2Ys5lPMfcwv2XBsYizmLGEshSynGcZYFlkZWJVZnVmTWatZL3OOsGGZhNjM2MLZytiu8Q2wvaDnZddjz2APZ+9if0x+zcObg5djgCOAo5mjmGOH5wCnEacYZzFnG2cr7gwXFJcdlxJXMe4ergWuFm4Nbn9uAu4L3G/4EHxSPHY86TxnOTp51nm5eM14Y3mreC9w7vAx8anyxfKV8p3g2+Wn5lfmz+Ev5T/Jv+cAKuAnkC4wBGBboFFQR5BU8EEwRrBAcE1IXEhJ6EsoWahV8J4YTXhQOFS4S7hRRF+ESuRnSJnRV6I0oiqiQaLHhbtFf0mJi7mIrZXrE1sRpxD3Ew8Vfys+JgEnYSORIxErcRTSZykmmSYZLXkoBRKiiQVLFUp9UgaJa0iHSJdLT20DbtNfVvkttptozIEGT2ZRJmzMpOybLKWslmybbIf5UTk3OWK5XrlfsqT5MPlT8m/VGBSMFfIUuhQ+KwopeinWKn4VIlOyVgpXaldaUlZWjlA+ZjyMxIzyYq0l9RF2lBRVYlVaVKZVRVR9VGtUh1VY1GzVdundk8dq66vnq7eqb6qoaIRr3FJ45OmjGaYZqPmzHbx7QHbT22f1hLSImvVaE1oC2j7aJ/QntAR1CHr1OpM6Qrr+uvW6b7Xk9QL1Tun91FfXj9Wv0X/m4GGwS6DW4ZoQxPDAsMBIyYjJ6OjRuPGQsZBxmeNF01IJmkmt0yxphamxaajZrxmfmYNZovmqua7zLstCBYOFkctpiylLGMtO6xQVuZWh6zGrEWtI63bbICNmc0hm1e24rYxttfscHa2dpV27+wV7Hfa9zowO3g7NDqsOOo7Fjm+dJJwSnDqcqZ39nRucP7mYuhS4jLhKue6y/WBG5dbiFu7O5W7s3ud+7KHkUeZx1tPkmeu58gO8R3JO/q8uLzCva5703uTvS/7YH1cfBp91sk25Frysq+Zb5Xvop+B32G/eX9d/1L/2QCtgJKA94FagSWBM0FaQYeCZoN1gsuDF0IMQo6GLIWahh4P/RZmE1YfthnuEt4cQR3hE3E1kikyLLI7ii8qOWooWjo6N3oiRiOmLGYx1iK2Lg6J2xHXHs8CP577EyQS9iRMJmonViZ+T3JOupzMmByZ3J8ilZKf8j7VOPV0GibNL61rp+DOzJ2Tu/R21exGdvvu7koXTs9Jf5thknEmE58ZlvkwSz6rJOtrtkt2Rw5vTkbO9B6TPWdzibmxuaN7Nfcez8PkheQN5CvlV+T/LPAvuF8oX1heuL7Pb9/9/Qr7j+zfPBB4YKBIpejYQdzByIMjxTrFZ0oYS1JLpg9ZHWotFSgtKP1a5l3WV65cfvww/nDC4YkjlkfaK0QqDlasHw0+OlypX9lcxVOVX/Wt2r/68THdY03HeY8XHv9xIuTEsxqTmtZasdryk7iTiSffnXI+1Xta7XRDHVddYd1GfWT9xBn7M90Nqg0NjTyNRWdRZxPOzp7zPDd43vB8e5NMU00zW3PhBXAh4cLcRZ+LI5csLnVdVrvcdEX0SlULc0tBK9Ka0rrYFtw20e7WPnTV/GpXh2ZHyzXZa/Wdgp2V11mvF93A38i5sXkz9ebyrehbC7eDbk93eXe9vON652m3XfdAj0XPvbvGd+/06vXevKd1r7NPo+/qfbX7bQ9UHrT2k/pbHpIetgyoDLQ+Un3UPqg+2DG0fejGY53Ht58YPrn71Ozpg2Hr4aERp5Fno56jE8/8n808D3++9CLxxdrLjDHsWMErhlfl4zzjta8lXzdPqExcnzSc7J9ymHo57Tc9/ybuzfrbnHd078rf879vmFGc6Zw1nh2c85h7Ox89v7aQ+4HxQ9VHiY9XPul+6l90XXy7FLu0+XnfF84v9V+Vv3Yt2y6Pr0SsrH0r+M75/cyq2mrvD5cf79eS1qnWj2xIbnT8tPg5thmxuRlNjiVvfQug4RkVGAjA53oA6NwAYB4EAE/8tefa0oCfyAjUgdgZMULpodUwHFg8jppKntqNJht/k4CjIxPbGPCM4Uz3WUisVeyAI4xzgFuF5yDvPL+uQJHgkDBeRF3UTSxMPELCU1JfildqSfrutgqZMFktOTq51/LNChmKdkqCSh+Ur5L2qNip8qi+VWtST9bQ08RrPtlepeWvvU37s06b7k49fX2C/muDG4aNRtXGxSa7TclmOuYc5ksW/ZZNVtXWNTadttP2WAdORy4nBme087rLmhtwp/EgetLtwOxY9pryHvS5Rb7sW+dX4V8QkBIYFOQYrB+iHCoVJhjOGUEfiY78GjUVPRhzLfZU3IH49ITcxJZkTEpA6q2dYJfYbo10swyPzISsA9llOWl7lPdM5xbttc0TzactAIWofYz7JQ5oF1kfdCl2L3E/5FrqXOZYbnfY+ohFhclR/UrtKvVqpWMyx6VOyNdY1GafnDhtVneufr6BsVH0rMI5zfOGTVbNLhe8LwZfir6cdGV3S1brnra89sKrRR1l16o6665fudFzc/TWxO2RruY7gd0c3fd6yu8m9Qbe29Hnct/ugUW/yUPTAcdHMYMnhp4/oX0qN2wwYjZq9EztuegL4ovVlzNjz17dHj/5OnsiaNJpynra6o3NW5t35u/VZ9hnJmYL5pTnJubPLKR+MP1I/bHhk8mn6cWTS8mfvb7YfLVaDl3p+r73R9uG4ebm7/wroDHoWcwEdhq3SI2mUcEH01YRJohS9EkMd5k4mVNYnrIpsmdxvOIicefyDPJx8bsKFAt2Co0JL4usiM6JPRQ/KRErqS1FLfVU+vi2UBmSzE/Zu3IH5F0U+BXeKzYpJSprkRBSj0qBqo0as9qIeoWGhyav5hgcBZ7anNqjOod1PfTE9Nb0hw0uGu4zCjDebsJo8s6006zMPNEiwNLXKtg6yibC1tfOxl7TQcqR24nojHJecXnvOuJ2x73Jo9KzYEeqV4i3q48hWc6Xww/xm/MfDugObAmqCy4PyQmNCnML140Qj6SDI2Eyejzma5xgvHdCReLtpGfJ0ykLqas7aXfx7ZZIF8jAZbzObMkqyo7N8drjlOu6NyQvO7+64Hxhy77W/VcOXCw6f7Ch+HTJiUOVpWVlReX5h7OOpFREHQ2qDKnKqL55XPLEmVrxkyWnnpxerSee4WoQbpSC40D1vHaTYbPVBbeL4ZdyL5+8cqNlqHW8bab9Swf6Gnun9HXNG7o3VW8J3kbdnurqvdPSXd9Tefdg7557qX2x9+Mf5Pd3DrA92jX46jHXE52njsOBIxmjp589ev71JdOYzCvL8ejXhyeuTT6eGp+eejP/Dguznzk7NM+4IP+B9FHsE/2n74vvlkY/3/9y9WvNcvqK8zfxbyvfO1dTf2iuEdYNN2Z/518WmUdVo70wklgq7BJulmqOeopmiRZPEKXTI7rTZzKcYxxi2mQRZTViC2Xfw3Gc8wpXD/c9nru81/hq+JMF9AV+CJ4SshCaF84TERfpEvUSXRUrFZcXvy8RJEklWS9lKvVeOnebxLYeGT9ZIFstt13umXwC/LppVrRUnFHKVuZTbifZkxZU9qjyq7bBr5YZ9XQNNo2zmnqaj7f7bf+olaZNpV2po6wzopuqx6fXrm+j/9wg2GDTsNbI1pjG+I7JTlNl0zmzWnNPCw6LEcsyKwdreus+m2xbTduvds32YQ7iDm8ca5x2OHM6P3UpcjV13XRrcQ/3EPF45Vm+w3rHilept6j3FR89nxfkZF8h32dwHQkOMAlUDVIPNgshh0aEkcN1IhgixiJPR0VEk6LXY+7EFsTZxrPGv0w4nuifJJb0LvlYilHKWGp4Gkvak53Xdt3Y3Z1+J+NqZkNWeXZ2TtQej1yjvVJ52Lyn+RUF7oUihWv7JvY/PHC16MTB3cUeJRqHuA6tlo6UXSo/fHj/kZKKmqOXK+9WPaueO7Z2gq5GoFbppOkpz9NRdbvr88/sa8hoJJ9VPUc89/n8h6bVC4SLfJcUL9teSWu50vq9Xf1qdEfFtQud7dev3ei7uXzbpOtqt0PPcm95n9L9p/37B3wGzR7rPdUfCX9OHJufGphb/rpKyf+v2hvlnYBTAeBQJtyh5gLgpANAcTcAYsNw34kHwJYOAEd1gBILBChCP0A0Jv++PxCABjhACyuUHIAfiAN5oAHrLjbAHdZC4uDusggcA03gBngEJsFXuHPkQRQQE8QbSUKKkXPIPeQdCoeSQFmi4lDVcJ+3Cfd1ieir6J8YE8whzBRWCZuHfY3TwFXg1uAO6z61KnU9DTdNMZ4Wn0+Lpz1I4CLU0ynTdRK1iB30avTXGEwZXjLGMzEwnWc2ZB5icWQZYrVhfczmzfadvYJDi2OccxcXN1cHtxcPDU8nbyKfMt8X/ksCsYIkwXWhXuFykWDR7WJEsQnxyxJ5kr5SetJi24jb1mQ+yr6RG5ZvUUhTVFAcV8pTJil/IrWrlKimqPmrW2rIa7JvJ2rJalfqSuvt1+8z+GREbcxqwmnKYyZirmxhbRljdcS62+aznbC9i8MBx15njIuha65bvwebp++ORq83Pjgyoy/Od9nvrf9YwFwQfbBFSFno+/DtEaWRH6PNYxrjCPExCS+SjJPbU2XS6nYJ7K7MYMsszsbnZO5Z3huaN19QuC/iQEsx4yGu0g/lDUe8j7JVDlbvP25yYrm26BTL6by6lTNhDZ/PHjxv1Mx4YenSuyszrfPt7zumO5dust82uOPV49Pr0KfzQO6h5COVocgn30cxL2jGjr9mnrzxljizc17vQ/Ontc8qX41X8N/2f7+/OvPj7drz9SsbB3/6bspvrR+U/FPB+h4TrDkIAimgBLSAKawz+MAKQxrIBxWgAVyFdYRXYBHBIlyI/Fb2U5BS5AIygHxA0aOUUO6obNQl1Fs0P9obfQq9gFHB5GCGsZLYTOwYzH0lFaAKphqmNqJup5GjacRL4s/RKtPeJNgSpumSiTTEMnpB+gtw//qSMYmJjamN2Zn5A8suVjzrETYZtvvsURzsHLc4Q7hYuG5xR/GI8IzxVvC58nPwPxeoFvQXkhcGwk9FzormiHmKK8O93Jxkv9Rl+BYrksmW3SkXL++noKtIUBxQKlC2ILGTllSeq/aqtarXauzTTN2eqJWv3a7zTU9J39+g0LDOqNX4msk10+tmfeaTligrKWtnmz22bXYLDiKO3k7VzuOuQm6h7q2eVDtcvI569/gMkbt8G/zy/EMC7ANNg9yCs0JuhdGF+0Z0RnFFp8a8itOPb0ikT4pOfpAqmJa4c3A3Kf1UJndWaQ5+T1ruQh45f6owdb98Eergq5KLpYnlyoc/V1ysTKjWOPbjRF2t4snqU+/rxOuDz1xoZD9bdV6r6cOFikvqlwdayK1r7bUddp3gesNNy1tLXce7fe9q3BO8j3nw8GHiI9xgwWPCk9ph71Gr5+Ev61+9n+Cfsn2T+e7GLPv8wY9iiw+/lK7sWzVbU1w/tvHm59Lv/GMADazpcsDsS8NakwGwhRWmCLALzvwacAXcA+Nw3hMQMUQX2YGkIZXIdWQSRQOzTkaVoQbRrOgA9HUMDyYDM4d1wz7EGeCuw3rKbWpL6lc0cXh6/AVaZwKa0EYXQ1QgfqfvYahgTGByYzZjMWe1YzNnV+WQ5CRxeXOn8MTz+vI58lsLWAlaCVkKW4nYi3qLxYnvl2iUvCc1u41ORlU2UO6o/Igil5K/cjNpTdVW7aFG/nY3bazOQd11fQuDbJjBNuNOkxumA2ZrFhaWrdayNufsZO1bHQ2cRlwi3PDu5zydvRh9aH29/T0C3gRpBheGvAuzD++PtIp6HOMROxOflsiXNJ5yN+3Wrup0p4wfWTU5zrn8exfzrxfu2x9YZFLMWfKgNLBs5XB2BePR2iqV6ofHA2uQ2qpTaqeH6xMauBvvnUtvMrkgd8n4SnprbXtRh1sn+/XRm5W33e5QdZ++q9x7rc/o/mh/8oDcIHpo8cnM8NBo8XPxF9Uvf74yGi94/WCSfspp+sSb2XcK78NmTszem5tbwH7g+Sj/yXDRZYn82f+L7Vehr8vL+1d4Vhq/qX87+m31u8v31lW21djV1tW1H7o/cn70rRHXHNYOrw2uU6/rrievX1yf3RDccNso2bi/sfFT4af/z8M/H/z8uamwGbB5ZLOfkv+4QCVFytsDIAR9WH4c39z8IgYAVQkAG8Wbm2u1m5sbJ+FmYwyAW+G//s+hKFP+J6papKAH7T8yKNd///4Pun3FWLWQgIoAAAGeaVRYdFhNTDpjb20uYWRvYmUueG1wAAAAAAA8eDp4bXBtZXRhIHhtbG5zOng9ImFkb2JlOm5zOm1ldGEvIiB4OnhtcHRrPSJYTVAgQ29yZSA1LjQuMCI+CiAgIDxyZGY6UkRGIHhtbG5zOnJkZj0iaHR0cDovL3d3dy53My5vcmcvMTk5OS8wMi8yMi1yZGYtc3ludGF4LW5zIyI+CiAgICAgIDxyZGY6RGVzY3JpcHRpb24gcmRmOmFib3V0PSIiCiAgICAgICAgICAgIHhtbG5zOmV4aWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20vZXhpZi8xLjAvIj4KICAgICAgICAgPGV4aWY6UGl4ZWxYRGltZW5zaW9uPjEwNzE8L2V4aWY6UGl4ZWxYRGltZW5zaW9uPgogICAgICAgICA8ZXhpZjpQaXhlbFlEaW1lbnNpb24+NTI4PC9leGlmOlBpeGVsWURpbWVuc2lvbj4KICAgICAgPC9yZGY6RGVzY3JpcHRpb24+CiAgIDwvcmRmOlJERj4KPC94OnhtcG1ldGE+ClSA75EAAEAASURBVHgB7F0NQFRV9r8zDDAICggK+E1qKlRUuq4VUKmZK+VXaLt+pGyZtEX/BG0lLcks/JetbeyuZh/irvIvdNUoidh0S6hF05ISlEVEFBQUBGGAAQbm/7vvzFzefCEqltq72eXcc88599zfPfe+e+e9N6MqLS1lV5Tq1/Ub1vRJ3nN3eF6RGUVZQUBBQEHgWkLAaDTK3ZEXBS0ISBJtNwdTJLLZ1tZGKsQnmphEl5SU3H777U5OTiSvVqtRC2EUVSoVEcQURRBkAQRpCWHiQIuEkSMJYeKLIrTAgXFBiCoQUCSzZIEbkjhQQQINGdIVBOSRUEs5OkW0xDZ1R1gGkwwSB6aEorwhGIEAWRA5BMgHcIggHwSTbMqdRBWaaG1tFQ2REVEk4yhCF8IokgAIYooimSUB0hLCqAJNblAuFyYOdUdIwjipUCtkivwnmiwgRyJJYYd0IUwEakmAcgV/Ak0ALnADPgJMBX/AwuNGShSExAFERBBTFEEISM16pskiUCVh5EhCWMFfWX8QDBoRNJdCNKU+Pnjb/V+kzhkOLZcRjGm0l6KuyCoIKAgoCFxPCMgvzIIWBHpCtF0OXXRRJWoFRxCilmTAp6rm5ma6coNP12/aShJNVZDEtkBYIJqYBDEJgwMZ2kAgFz6DIBUQkDQYDNQELpAokhjR5APl4CNBgKqEQWoCRqhRYQSt0/mB+NAlOyiCIBpMclKjMV2YqErkpIu2QKAJCEPFam8NJtmEGNHIiaBugoZ95DAL96BO3lIrMEiJ60gysEYGkYNDzRHNK8ynL6EuWgFBpkiGrJFXVAUVEiAV0JBU8FfwV+Kf5iamA4JB0CDAoZyCBEVl/cHCQgsIkAEsRBNToIQiEgRQCwI5AUsCpAL6511/VNK9kab9m1dMX7qZsRF/+uTDmXf4kIum3FCxc80Lz/zlcxSf+NP2+Jmjz+xaGroQwkhzvih68cBDwyqf3+z64ZxXP2cPLt789nP3uTNWsX/znOlLj0DiT5+snnkHY/W7lj57Mmx6ycKFB5d99q+nbpXUlUxBQEFAQeBaRIBWduGZvEi0LQfCokpOgKZEAqBB0LVBTlAt+ETg3khISAguD0hQQU58KoKuq6s7duzYmTNnzp8/j2LPnj0DAgKGDBni4eGBIhJdY4Q8OMIUdAsLC211u3fvLuTRKF20kJNXsACisvrsfw5n5xXnFp85qTK2Dewz6JbAkLtvDevt409dI2+RY6NA+yriQBfGuWdm38BHEtdCKmK7DwGiQUBFrogiJRgnRWGBjhakgpy0IAwBFJFIHnw0QcJCBrWiFWqaek1tgQMCMkQIg9yoOUGALIhaak7uANHCFKkKRVEkC8hhAUzyhGqFkyhCUa4LWigSfYPh31p76lBh44iRN7uZB5QwoVxAcdn4N5wrPFquvf22ATjZw+ZPjD9v/Yzrrbf0c1Hi/+fAn0Ycg66sP2IZ+YnXH1Veaan+y4SRc7TZJ5b2OpY6bHz2lyfeHtJ+y8TwZcKgOfnLsjcu6FWz79lfP9pr477V97O3fvPrXeM2fxjzK093tv3xYbGfs5c/yn7I59DI8X/9pOBfd+j+1W9k1MZ9RQ94/ffZYb8JzS6aOciw+fFhSz8f8ZfP3r3/pgBPd1f5OqLQCgIKAgoC1xQCYk8Dr+zSgmlFoEgcIkROdqgKe0orQogJAqeRO+64g8SgSxcG2oxi41VWVvbjjz9WV1f7+/v37t0bYmfPnq2oqPD29r7lllv69u0LGWxGoQgCORHgwA50Dx8+XFNTY6sbHBzcr18/sbGDFiyjiET0kaIf077+5/dluT6DfPr0R7ttZScrzpdU39H/jqn3PDL8plsgCRXhJ2mBQ/5TrdwmSZIKji7kIWlBBXzhAwiiBYFaustBkuQkDKJIZkleNEqKyOk0AgKSqCWghBGhS4qkhVoQVCXnUy35CZqqkCM5wp+EYRAC1GUoUuuoAgFd4QM4kjET/igSh1SQE2KQAV84IPwER9K49vFvyPrgL/8+Z9RKHWlqqukXGv3E+EDqFHW2sWDzY8s/XpGceot745d//d+8YfP+MC4QVUhCjHAgxBpKs9dt2NvsJiGj7XHHfZMfuK0P4QwVW/yPbn7ipbT73k+d06NT+DdkrVtzeNi86PsH0JBdIf5HNy9Y8cn97374O0/z59YmV5uK33tp09Bn4u/tz3dNoqcgkJT4v1Hi37QCIHTF3BeTmsIVuZjXGHoURRJFefxfh+sPa/oh4z3G7v5wzWqmL2Ts5PkmPHll7qahFJXLPpk1yF3D3O9Z8vLd4z/89uUHHujjzbx7+fi44y5IffNJ9sTmg4/f48ea6u5m3tA8ceBr5Lv/sfYgq9nO2E3VejZIw06yZz76cOqtljdezO0ofxUEFAQUBK5xBMSiLwjhMHGQywkqyjmQxxVF8EUVMeW1uJbgoR2SBB9bE2oLkvX19bm5uU1NTePGjevTpw/dDMHtDtzr+Prrr3FK6datW48ePehqRLsuZ2dnKIIDMQh0oOvu7g517NdxYYO8aUskbYPO1Zzd8XXqj9X5c5+eNvnmiQFut8OlssaDOwrS/2/jLuPXrfN79PT17AUmXVOJQI6mySB1EzZBIKdrJxXR05aWFmqUatE6mKgFQR9YgoAADIIPAgkcFKGInJKoQpFowQGBBD7ZgToehIN9MJEDbbJA3iKHgKTBVSAgaokvOMQHk1SIQC35RoTAH8Ikhhy0aBQE5EkYVXbxhzyMI1EviIAKdJGTZVFF9iFD/Gsef9WF/EMFqtsi7uiPLrS0eHl7uaBfcvwNzl5OTv2dDRg0Q82ho4e8Wzh6rdVZaV96h066tbeWgEWXQQCQlrrK/QW5PW4LD/OsTs/O/mF/9snYtx6/05fECB9uQUognD17OPX0UrW06B3gX110cO/hxvsmh3upERJtNYeOHPJugofQvXL8Xb091d5eztIdRfIf8QDjGN38kwXejQgPflanAQUfBBLFmBL/V44/IFXWH8CIiEL4/SzrDz92NOP/BydHRI5ijS0Rv3W7yeK+haEBb4aYn+JlqKprxvTlKuaEw4ufj+nZADNPz9j0iVOn+rS0RETM730TDi1NEPPsobxeYkZI+asgoCBwrSKAK9MluWYlj6I8wRQVQWCht6qSc4impkEjkS6uDaRFW5Di4uLGxkbcOfH09NTr9Q0NWKT5dhlFPNz13Xff4b5KUFAQmJCHEbrG4DID4vjx4x3rnjhxAndI0BwUSR0EOXDwyH9+OH/4rskhQQOHFLWdOHzhv2jCTeMSMmhEyeST/0n7Yf/h7N/cPRVMtAUVEJTQLggwYRY0crIMJorYBAgB6iAEIAyatJDTho/U4Q8IJBIQfpKTfFvpjE0dH0HkqAVBCfJCC7RoF7XUHJhkHDkS2YeKFf5kBDkUKQcBYSRogUZ3YJCY4FARHCKEClVR30kLORLsQIYcQI5EDgizIEgGwqiFZbmHYBKH25ISNQEmzIJGLndV4AAB8JEgQDS0QSD/CfBXq536jf99dOQQctKgr7tQzzcaKFLurIbzKqBjNLr9bmvm/OYLZ2v0RmP1Rzt3ht3yYLCvKVwhbAIKzzw5OU2Pei7yZrenz/579hNv/vdERWuINxmEGKCDJBJoJJWKm0djhABqQSBHInhrD2/duZMFPXi3pxb4d/vt1sx5kg+AqCvwVzmpjThzOPN3hxBy5vh3Hf5BRkbThXO1TTzs4S38AYEE9+A2iuQn+aDEPzChEeGDKiUaYjABGmiCDrihEsVrJP4xiDSOcA++IaEID1GURxeY5D9yqpW6yIMWCVrUKZq2xEEfUUQighQhBmFwkMiCIKAFGXIAORI5AAEYIfskQ0bAlHsIJnHILMkTE2ZhBLncVYE/TiOuoyY+web8u/G1GaOHuBrqL/DWRNIMeng6i3r3X5FvT/WsP/rh0m+m/+V1d6bx9mff1DUKKSxWMpoNGjWOsaii2mX3jfZjhvr6dovmzyGqfvwwNTdk+m9v9RN3YeQGFFpBQEFAQeCaQECs3cIbOceKRlEkyIMmLSKwrItawQETMqKKtEQRBJZv5EioomvAuXPn8JCVi4tLbW0tcjytgSrsQvChMYqowiNbI0aMoLZIHVcLWID6RXXxxBd0YZASjEALVxfkRyuOeA737tZDm3s2v4fWy9XZGTJNLfoLjXVunm5eI7wLzh590HwRpesWtCBDnsAH0PATTOo+iuQVCVCRWqRGQcN/8KkKOcySAKlQTlc4ahEyuLxRE8gFISyAIAvEEVp0QRX+gE+g2eIvLMA45Mka+UDeElP4hqLAn5iwAF0SFht9MG0TGYczkKccMjBIXommUUU05ZABBzm0kIOJdG3j34aNoaqhobKyEj4jARYO2oWjm99as/cUOtF//IO+arW7sQ2f3TZs/+OSQ7csWHSv5q9LXqlXqzPefj5DN2jJn58b7sGjxYR/Gw+ehtryynPdNC6+A9XqKifTtxewuuOb31otmXV/+JllU27nzzq2GVVqvAiFz4ZZ6w9pG5I

                    • 7. Re: Conditional or dynamic value list?
                      bburdeen

                      Trying to upload pictures...

                      • 8. Re: Conditional or dynamic value list?
                        bburdeen
                        /files/c47c455a3b/Dwindling3.JPG 879x563
                        • 9. Re: Conditional or dynamic value list?
                          bburdeen
                          /files/5b41ddbb41/Dwindling4.JPG 869x772
                          • 10. Re: Conditional or dynamic value list?
                            bburdeen
                            /files/8dfd4c1cb1/Dwindling5.JPG 653x173
                            • 11. Re: Conditional or dynamic value list?
                              philmodjunk

                              What does one record in "Baseball2015" represent?

                              Which field are you attempting to format with the value list of available seats? Id? or List_Seats?"

                              What I don't see is a calculation field that generates a list of all Seat IDs from the Join table as the list of all previously selected seats. This can be an ExecuteSQL query or a calculation using the List function.

                              • 12. Re: Conditional or dynamic value list?
                                bburdeen

                                This db is just a simple signup for a baseball game where they can select an actual seat in the ball park. So the idea is when the next user creates their record the previously selected seats don't show anymore.

                                The field I'm attempting to format w/the value list of availabe seats is Name_IdFk.
                                List_Seats is showing the ID from the Seats_List table.

                                I think I had the calculation and then deleted it... I've added this back in and have it working again, but the "dwindling list" starts fresh with every new record.

                                The calculation I have in the "Set Selected Seats" script is:

                                Set Field [Baseball2015::List_Seats; "0"  & ¶ & List ( Join_Baseball_Seats::Name_IdFk )]
                                Commit Records/Requests (No Dialog)

                                BTW - I really appreciate your quick responses and patience with me. Thank you!

                                • 13. Re: Conditional or dynamic value list?
                                  philmodjunk

                                  Then one record in BaseBall2015 represents one purchase of 1 or more tickets.

                                  To get a list of all previously selected seat ID's, you need either a second occurrence of the join table linked by the X operator to match to all records or an ExecuteSQL query that does the same thing.

                                  Baseball2015::anyfield X Join_baseBall_Seats|all

                                  would enable List ( join_baseball_seats|all::Name_IDfk )

                                  to return a list of all selected seats in the table.

                                  What you have seems set up to either sell season tickets only or tickets for a baseball "season" of only one game...

                                  • 14. Re: Conditional or dynamic value list?
                                    bburdeen

                                    Phil,
                                    I have this working the way I want, thanks to your help. The only thing is, I don't understand how I did it or if it's actually correct. Maybe you'll be able to spot something from these screen shots.

                                    I do have some triggers happening on the layout and when a seat is selecting, all just running the "Refresh Seats" script.

                                    1 2 Previous Next