We would like to provide a MotoType dropdown to our users of OpenPlant so that when then place a motor on a PID, they can just pick a MotorType from a list.
We know that we can create a lookup list by adding it to the schema. But we want to leverage the MotorType table where there already is list of MotorTypes.
Is there any way we pull the data directly from the table into OpenPlant as a dropdown/lookup list?
thanks very much
This can be accomplished by adding an External Data source Definition Mapping custom attribute to the property.
The steps below is to add a list to Device Type Code property on Instrument but you can use this as a template for your "MotorType" requirement.
NOTE - The current mapping custom attribute will only work with the Jet.OLEDB connection string.
Now when you insert an instrument and pick on the Device Type Code drop down list, the values will be coming from the Schema.mdb, ins_pick table.
I hope this helps,