Jump to content

Should be an easy calculation...I hope!


This topic is 5698 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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.

Link to comment
Share on other sites

This topic is 5698 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.