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.