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. Data for each step
is captured in a seperate table with ProdID as 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, display the data
if it's there but don't have empty fields if the record(ProdID) does not
exist in the final table.
occasionally an additional step is added for some product. Data for each step
is captured in a seperate table with ProdID as 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, display the data
if it's there but don't have empty fields if the record(ProdID) does not
exist in the final table.