I am using a database to track shipping infomation for a specific product.
There is a structure type that I track in one table. Sometimes there is a quantity of one but other times it could be fifty. Each structure is made up of two or three sub components that I track in a second database. The sub components ship as they are completed. I can only cut an invoice when all of the structure has been shipped. I track the quantity of sub components that ship. I would like a way to determine the smallest quantity of the sub because this will be the actual number of complete structures that have shipped.
Is there a way to track the least number of sub components related to each of the main structures?
There is a structure type that I track in one table. Sometimes there is a quantity of one but other times it could be fifty. Each structure is made up of two or three sub components that I track in a second database. The sub components ship as they are completed. I can only cut an invoice when all of the structure has been shipped. I track the quantity of sub components that ship. I would like a way to determine the smallest quantity of the sub because this will be the actual number of complete structures that have shipped.
Is there a way to track the least number of sub components related to each of the main structures?
