Cue - Multiple Tables

nickrobbo89nickrobbo89 Member Posts: 10
edited 2015-03-23 in NAV Three Tier
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.
Sign In or Register to comment.