Insert named query into memory dataset column


Is there a way to insert a named query into a dataset column cell?

Or should I be doing this another way?

My dataset is called from an indirect binding on a subview table. I want the comments cell to be a query of the latest comment in the db for that machine (SAP).

Where does the rest of the dataset come from ?

It lives inside a memory tag dataset.

I am thinking it would be better to build out all my machines into my db table and then just created a filtered name query to bind to the data property of my subview table?

Yes. Put what should be in a database, in a database.
Then use the machine id to display the pull the relevant data when you need to display it.