I have a form with lots of dropdowns which I link with the Link Wizard to small tables containing the integer value and the text "what that means" lookup.
But I thought that to minimize database lookups during Form fillout that in some places I would use List of values rather than querying another table to generate a dropdown.
So, I know that when I am using the Lookup Wizard that I can simply put in text values using the List Values generator, but I really want the integer equivalent to be the stored value for that field.
Is there a workaround that will store this list of values with both the integer and the matching "read only text" while using the Lookup Wizard "List of values" option?
Second question related to the first one:
In the ADD page visual editor if I select a specific field as if I were going to right-click and select its "Properties" but instead then hit the INSERT PHP CODE SNIPPET function does the PHP code written and saved actually then apply to the Selected field in the ADD page form? So that if I wanted to generate a dropdown as mentioned in my first question with an integer value but a matching text value for display that the PHP code snippet would apply to this specific field?
Thank you.