On-the-fly Calcs with Inclusive & Linked Files

February 25, 200520 yr

I am in the process of building a 'cash register' database.

The enclosed files will help explain much better.

I initially created the database to be all inclusive in one file.

As the line items were entered, the subtotal, tax and total were all calculated on the fly. Everything worked great. (first layout in enclosed file)

Now, We would now like to separate the data from the layouts..in two separate files.

Now, in order for the subtotal, tax and total to calculate, the user must first click outside the portal. then it calculates. (second layout in enclosed file) I presume, that all of the information entered does not actually get sent to the linked file until after the portal is exited.

Any ideas on how to get this to get the linked database calculating on the fly once again??

Is there a way to force the data to be sent as the fields are tabbed through?

The attached file is a zip with two .fp7 files - Open the TEST Application.fp7 first.. the other is the linked data.

TEST.zip