Cue creation from two different tables

SRP0641

We are creating a cue in navision where the data will flow from two tables. The data from one table is required to be deducted from the second table and the final remaining value should be seen in cue. is this possible and how? Please suggest

nick_robbo

One solution is to use a Query object to return the result set you want.

https://msdn.microsoft.com/en-us/library/dn789551(v=nav.90).aspx

sorenhinrup

You can, on open on the activity page, call a function in the Cuetable that calculates the number you wish.
Do you want to drill down on the cue as well, then and see the combination of data, then I think a temptable with the combined dataset is the solution.