A point about the in-memory tables. The two tables, Employees and Products, were automatically brought across the Internet and loaded into memory the first time the application retrieves some customer records. That slight delay pays off handsomely by making virtual field retrieval and display instantaneous. FYI - there are 9 employee records and 77 product records in this sample. This is a fairly sophisticated application, delving into much more than just one to many to many retrieval.
Several options are available to control what and how information is retrieved and displayed.
There are instances of calculated fields from in-memory table lookups as well as numeric calculations. Of interest is the methodology to control blocking or synchronous mode of data retrieval. Since we could be operating over the Internet, delays can occur in delivery of linked record sets. By setting the Asynchronous mode option to synchronous, you can ensure retrieval of only the pertinent record sets, thus preventing a backlog of requests at the server. We also demonstrate turning on and off the retrieval of linked sets, making it easier for the user to scroll through the customer records and retrieve the relational datasets as needed.