On-the-fly Calcs with Inclusive & Linked Files

[MarvinJ920]

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

[MarvinJ920]

Does anyone have any suggestions??!!

[-Queue-]

You could use the EventScript plug-in to trigger a Refresh Window [Flush cached join results] step after exiting the Price field.