I have an invoicing database.
When an invoice is created, a status field automatically enteres "open" from a value list. The value list has just 2 items: "open" or "paid"
When I get paid, I have a related database for earnings.
As I enter information about my payment, I'd like the status field to automatically be set to "paid" as soon as I type in a dollar amount in the "amountEarned" field.
I'm having a tough time figuring this out. Hope this isn't too simplistic for this forum.