Should be an easy calculation...I hope!

[drjay]

Hi guys,

Newbie here with what should be a quick one. I'm trying to keep track of customer credit between two databases. Database1 is the general customer info with a field I created for adding in any credits due. Database2 is the invoicing bit where we add up their totals. I've managed to create the necessary fields so that Database2 looks to Database1 for the credit amount, but I need it to then subtract that amount from Database1 otherwise they will always have a credit. All of my solutions so far have been met with FM freaking over a circular sumbit.

Keep thinking it's going to be a simple if/then/else solution but I'm not very savvy with FM.

Thanks for any direction.