Windows XP 
Access 2010 64bit
Hi all, I'm working on Access 2010, I'm a limited Experience administrator, trying to learn this stuff as I go.
The database I'm working on is a product Database. It keeps track of everything we produce (imagine that).
The issue I'm having deals with a need for a recursive, or "self-join" relationship that is connected with a many-to-many structure capability. I need to be able to identify a list of all parent items that could be used to create the current product.
Our products go through various phases starting with the Incoming Product and ending with the Finished good. The product name and ID from each phase need to be visible from every subsequent product spec. Below is a sample flow chart of the development of a product.
Incoming-|---Work in---|--Finished
Product---|---Progress--|--Product
A ---------->B ------>C -------> D
G ---------->H ------>C -------> D
E ---------->F ------>C -------> D
I need to be able to pull up product C for example, on my form and be able to see that we are able to arrive at product C either by taking Product A and turning it into product B and then turning it into Product C, or by doing the same thing to Product G or Product E.
I hope that makes sense.
tblProductInfo
- ProductID
- ProductDesc
- RawMaterial (somehow needs to show a list of all the parent ProductIDs and ProductDescs)
Reply With Quote
