Share
Report
20Hi. Working on a new extension for my company to configure our products and store engineering data.
In my top level table I am trying to reference the data of another table with component Engineering data. So the top level table uses a field that looks up the component ID (primary key). Then other fields in the top level are flowfields of Lookup type that pul other component data. It works fine for pulling numerical data (like amp draw) but it gives me an error when I try to pull data that I have setup as Option Data type. About half of the fields for component data are option type.
How does one reference data stored in Option Data types , if at all? If I wrote a procedure for the OnValidate trigger for the primary key drop down, would that be able to reference that data using Find?
I have also read that Enums are the newer and preferred method vs Option and OptionMembers. Would this work as an alternative?
One last question, is there a way to limit the input with options at the Page level vs. the Table level?
Thank you for taking time to read my question.
Regards,
Jeff Johnson
All responses (
Answers (
