I'm running 2 database that share information. Main Dbase is "Requests" and runs my workflow. The second Dbase is "Funding". I need to export the "Estimated Cost" from the Request Dbase and ADD it to the "Estimated Costs" in my Funding Dbase for a running total. There are 5 different areas with 3 Request Types each. So I need something like
- If List item [Area] = X
- and List item [Request Type] = Y
- THEN Export List item [Export Cost] to "Funding"
And this is where I'm stuck. How do I get the cost to go to the right Area/Request Type record? I also need to ADD it to what's there and not just replace it.