Valuelist populating more than one field

[jstalin]

I’m trying to get a form to populate the “date” field based on the “Order Number” that is chosen using data from a second table. I have the “order number” being chosen using a valuelists.ini file, but I can’t get it to populate the appropriate DATE based on the order number chosen. I need some help. Any suggestions?

[shannah]

An easy way to do this would be with a beforeInsert trigger.

Code: Select all

function beforeInsert(&$record){
    $orderNum = $record->val('orderNumber');
    $orderRecord =& df_get_record('Orders', array('orderNumber'=>'='.$orderNum);
    $record->setValue('date', $orderRecord->val('date'));
}


or something like this.

[jstalin]

Once again, that did it. Man, Dataface is awesome and you are awesome!!