Can one data view represent data from two different server tables at the same time

[bbuzzard (Billy Buzzard)]

Is there any way to join the data from the Customer and ShipTo tables into a common dataview without having to create a BAQ to do it? If yes, how?

[knash (Ken Nash)]

Think that is what a BAQ is for…

Else what is the reason for not creating a BAQ?

[knash (Ken Nash)]

Read up on this post. Might be what you are looking for.

Managing the custom is something you will need to determine on your end. BAQ vs tapping into the GetList Method.

Adding Columns to Existing Grid in Kinetic

In many cases, it might not be! There appear to be three main ways to add columns to a grid: The data is already in the set: just add the column… but if the fields aren’t already there, then no luck, right? Create a BAQ with all the columns, plus the added columns, and basically make it from scratch … but this sometimes doesn’t play nice if it needs to interact with other elements on the screen. Some finesse with a BAQ and some events to hack it together in the UI. (Thank you, @hmwill…

[bbuzzard (Billy Buzzard)]

I must apologize. I confused data view with dataset. I was able to get my code working using another data view that used a shared dataset.

[klincecum (Kevin Lincecum)]

Ok, but what were you doing in the first place?