Exeptions in data source

J

J

At our R&D facility, product manufacturing goes through a 3 step process but
occasionally an additional step is added for some product. The data for each
sep is stored in a seperate table with ProdID has the related field. What’s
the best way to handle this deviation in reports where people want to see the
full manufacturing cycle for the product that was made? ie, I want to show
the fields in a report if that product went through the additional step but
not show blank fields if it didn't.
 
Top