If/Then
I am trying to make an amount paid field autofill based on another filed if a I select a certain status. If that status is not chosen, I want the ability to fill that field in manual. Example, ...
Forum Discussion
I know it's not the answer you're looking for, but I assume that if a partial payment can be made, then more than one could be made. I would then make a payments child table and roll up that summary into your formula Amount Paid field.
------------------------------
Dwight Munson
------------------------------
------------------------------
Dwight Munson
------------------------------
I will second the solution from Dwight. It is a common problem that I have had to deal with.
This is the basic architecture. The Payment Type table is real important as there is always a management need to describe the money received for Revenue Recognition purposes.
------------------------------
Don Larson
------------------------------
This is the basic architecture. The Payment Type table is real important as there is always a management need to describe the money received for Revenue Recognition purposes.
------------------------------
Don Larson
------------------------------