you could use an OnObjectEnter script trigger, using something like Get(ActiveFieldContents) to check for the "N/A" value, and redirect using the "Go To Next Field" script step if the value is matched.
Thanks for the suggestion, Mike. Might be a tall order, but is there any way you might know that I could apply this to the layout rather than each individual field? By all means, that looks like it would work, but is a lot of fields to go through and setup a trigger for. I really do appreciate the suggestion, and will start looking into setting that up as in my mind, it seems like a layout-wide script might not be an option.
Actually I think that what you're doing at the moment is not that bad.
Probably the annoying thing here is that those fields disappear.
What I would do is create a text object that would look exactly as your lookup field with N/A in it.
Stack your lookup fields on top of that ( make sure the lookup field has no transparency so it will cover the object below ).
The tabbing will work and it will look like the original.
not really, the only close trigger would be onLayoutKeystroke, but you're not guaranteed a keystroke action when clicking in towards a field.
field level script triggers will give you the most control, but as noted, hiding object and even stacking/hiding objects may give you the best interface.
Thanks, Mike and electon. I'll give both of these a shot and see what plays out best. I appreciate the input.
By all means, that looks like it would work, but is a lot of fields to go through and setup a trigger for. I really do appreciate the suggestion, and will start looking into setting that up as in my mind, it seems like a layout-wide script might not be an option.
I have now took the policy to attach all triggers on all fields. They are all same generic scripts, one by event, all tables and fields have the same.
Thus, specific Field Name, Field Type, Layout Names, Modes etc...- behaviors are properly ruled in a centralized script.
In that system, a suggestion like Mike's one would very easy to achieve.
About the N/A, did you think about the v14 placeholders ?