2. ASPRunnerPro General questions
  3. Default value in the EDIT AS settings
This topic is locked

Default value in the EDIT AS settings

 		2/4/2010 4:26:53 AM
ASPRunnerPro General questions
N
 nonmipare author

When I add a new record, I'd like that the default value of a field were the value of the field Raw_Cost multiplied by the value of the field Mark_Up. Who can help me?
J
 		Jane 2/4/2010

Hi,
where are these values (Raw_Cost and Mark_Up) stored? Do you want to select these values from another table?
N
 		nonmipare author 2/4/2010

yes. I want to select these values from two tables. The first one (raw_cost) from the main table and the second one from another table (mark_up). Any idea?
J
 		Jane 2/5/2010

Hi,
sue Before record added/Before record updated event on the Eventstab to select these values from another tables, calculate and save result in the current table.

Actual code is dependent on how these tables are linked.