FM: All dropdowns must be attached to records. Not variables. Can't use a portal, due to dynamic table changes.
Not really true. You can define global storage for your field and then it is accessible from any record, on any layout in your file. A script trigger can perform a script that finds/sorts or whatever to produce the list of records you need. It can also update a portal to list different subsets of records in a portal.
2. I wanted nice rounded corners on my fields.
FM: Can not have rounded corners on dropdown, must be rectangular.
Please note the rounded corners in the uploaded screen shot.
As usual....you are all knowing and wise.
So....where did you find that dropdown?
I added a field to my layout and used the corner radius tab on the inspector's Appearance tab to round the corners. (Also enabled borders.)
I then click over to the data tab and specified the options I wanted for a drop down list.
BTW, this is a new feature of FileMaker 12. It's not available in FileMaker 11.
Ahhhh...yes, I'm running Ver 11. I'll stick it the rect in for now and replace it with the new one once I upgrade.
So, I assume by your comments, that refering to my screen mockup you see nothing 'not doable'. Then it's just a metter of me wrapping my head around this applicaton,
I see no obvious road blocks--but the intended function of every layout detail in your screen shot is not obvious so I could be assuming details incorrectly.