Reading access database : Grouped data

[Manreet]

I really appreciate you getting back to me on this.

okay ...so after I have this data , how do I update the table in labview so it shows up as a group ? do I need to use update table vi or insert , because just leaving it like this it does nothing to the table, it still shows up as duplicate entries

[aputman]

If you want it to appear similar to the way it does in Access, you've got a hard road ahead of you.  The best control available in LabVIEW would be a Tree.  Input the one row transaction data as a parent and input the step data as children of that parent. In that case, you probably don't want to use a join query but rather have two separate queries, one to query the transaction data and the other to query the step data.  You could set it so that the step data is only queried when the parent tree item is expanded.  

The problem I see is the different column headers.  I don't know if it's possible to create a custom control that is a tree within a tree where the inner tree has its own set of column headers.  Without a custom control, something like this might work for you.  I'm not sure how you intend to use this information.  Is it only for display?

[Manreet]

yes it is just for ease of use . Never used tree before so from the sound of it it seems way complicated. I have the rest of the database pretty much the way I wanted it to be , so maybe this would be a nice to have at this point.

Can I configure the tree (create parent & children) during runtime , because I am creating my table during runtime. wondering is it possible to do that for a tree ??? 

[aputman]

---

@Manreet wrote:

Can I configure the tree (create parent & children) during runtime , because I am creating my table during runtime. wondering is it possible to do that for a tree ??? 

---

Of course it's possible.  There is an invoke node for adding multiple items to the end of a tree.  Just create an array of the tree item data and feed it into this invoke method.  Try it out on your own, look up examples in the example finder within the LabVIEW help menu and come back here if you have additional questions. 

When you come back, please be sure to post LabVIEW code so that we can see what you are doing.  Please avoid using Word documents to post pictures.  Some people may be viewing these posts from their phone or may not have Word available.  The forums allow you to embed images directly into the post.  Help others to help you.