I would like to build a generic extractor based on a Z table. The problem I am currently facing is that the reference tables for the quantity fields are in tables which the relationships give 0 records.
Is there anything wrong if I request that these reference fields are also part of the Z table i.e. and than the quantity fields reference the Z table field. My concern is that on this request will the people maintaining the z table face the same problem as me when trying to determine a relationship. If it is not a good suggestion are there any alternatives? Thanks