After Insert Macro

[ositamay11]

I am having a hard time getting my after insert macro to update correctly...

Create Record In Customer

For Each Record In Customer
Where Condition = [Customer].[RepNum]=[Rep].[RepNum]

Alias Rep


EditRecord

Alias Rep

SetField

Name Rep.Commission
Value = [Rep].[Commission] + ([Customer].[Balance] * [Rep].[Rate])

End EditRecord

Any hints about why this macro is not updating the rep commission? It simply leaves it blank still.

Thank you!

 

[xenou]

Hi,
I've never used this feature but this site seems to have a good explanation:
https://msdn.microsoft.com/en-us/library/office/ff973807(v=office.14).aspx