ositamay11
New Member
- Joined
- Jun 25, 2017
- Messages
- 1
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!
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!