This particular problem has been a long time coming for an answer. The goal is simple–Populate a PopUp menu with values from a SQL table, then select the value in that PopUp with a result from an SQL query. Here’s my solution:
You’ll notice that the solution is not clean. Is there a way to select a value in a popup based on the value of the item’s RowTag? NO! (If there is please let me know). What I wound up doing was store the value of ListIndex in the table and select based on the queried ListIndex.
Well folks, being a writer and comedian does not pay all the bills. A new opportunity has been placed before me. It utilizes the skills that I learned long ago at the credit union. It requires me to learn two data applications: XOJO and Filemaker Pro.
I tried the demo to both and my thoughts are XOJO is Visual Basic and Filemaker Pro is Access. So the learning curve for both programs is good. I’m documenting my journey learning both software packages.
I am learning XOJO first. Why? Because it is harder to learn and less expensive to implement. This is my first taste of XOJO.
Managing Editor of Film Threat. Writer, Professional Comedian and Producer