This topic is locked

Events / Add page / Before record added

7/10/2014 8:50:25 PM
PHPRunner General questions
N
nti author

in need of Events script to do the following...
Two Tables Involved.
First table Name: (Lu_Co_Reps) Table with Two Fields: "RepName" and "Rate"
Second Table Name: (Invoice)

Two fields in Invoice Table... "RepName" and "Commission"
Adding a new record to: Invoice Table Field "RepName"
I would like to utilize Events / Add page / Before record added to do the following:
Check Table(Lu_Co_Reps) for field "RepName" and utilize the data in "Rate" Field to fill in data in Invoice Table "Commission" field.
End Result: (Invoice) Table Field "Commission" will match Table (Lu_Co_Reps) Field "Rate".
Extra Note: Not able to utilize Visual Editor Auto Fill for above event...