Cue - Multiple Tables

nickrobbo89

Hi All,

I am currently working on adding some functionality to a Role Center, which displays information from Multiple Tables. I am just curious to find out if anyone has had experience in this area, or any suggestions of ways to get around the problem. We are currently running NAV 2013 R2, I know what I am asking is possible in 2015 but we are not due to upgrade to this for a while.

I need to show a list of records, which are on a Sales Order, but not yet on a Warehouse Shipment. I realise you cannot use a standard cue as this would join across two tables. Our current workaround is to create a NAV query, which gets the correct data set. The problem is how can I add this to a Role Center, we can run the page but I'm not sure if this is the best way, also as it is a bit of a hack we cannot use an integer to display the Number of Vehicles which match this criteria on the Role Center. Has anyone got any advice or suggestions?

Thanks in advance.