Recent content by Sluggo

Here are some answers to the best of my ability. I do believe a better (for my people) method for inputting and manipulating data in a hierarchical structure is doable. My coding/vba skills are not great and understand that the query/report tools of access will not work as easily as a standard...

Hey CarlettoFed, Sorry for the delay. 824761|826233|826234 - These are the part numbers of the final product. - I had combined them as ~98% of the sub components are the same. (For example, think of a new car that comes with different trim levels. Such as the Volkswagon Jetta: Trendline...

Thanks for the feedback MajP. All of the parts are uniquely serialized. We are not concerned with recording non-serialized parts. The (X2) does mean there are two of the same part, but they are uniquely marked. I was just condensing the lists. There are still issues on the diagram. This is...

This sounds slight different from the example given by Minty & MajP, using 2x tables instead of 1x.

In the other thread "Hierarchical Data, Recursion, Tree-View, and a another Great Custom Class" there is a number of examples that MajP has made. Is the download from post #137 (Version 15) a good example, or is there a more stable version?

The hierarchical data storage does seem like the best option in this case, but it also appears that Access does not have a lot of native functions for this type of structure. Is it correct that most of the functions would have to be done in code? As in little to no SQL, no report/query wizard...

Here is what the hierarchy would look like graphically. (Starting in the top left) Each box is an assembly of serialized parts. The header contains: Assembly Part Number, Assembly Name, Record Document Part Number Below the header is the list of serialized components that make up the assembly...

I am currently drawing up the tree diagram in a program like Visio. This will help me show management where we would need to make document changes in order to fix any broken relationships. I will share it here as soon as I can.

Here is some sample data that has been stripped down. docs.google.com/spreadsheets/d/1PZieyPIjWKgaTLCMVLoWuDPNf5rR68EOOUxGEG0A1uM/edit?usp=sharing Notes: - All of our parts are given a 6 digit part number. Typically following is a Revision, Batch Number, and ID to which generates a unique...

I will look into this. Thank you for the quick reply.

Good morning, new member here. I was hoping someone could help me with an example or terminology for a database that keeps records of the serial numbers that have gone into the equipment that we assemble. Since the equipment has several sub assemblies; graphically this would look like a tree...