I am working with an SSRS report from an ISV Solution. The ISV has already extended a table that is used in the base SSRS SalesQuotation (SalesQuotationDetailsTmp table). Importantly, this table has a many to one relationship with SalesQuotationHeaderTmp, and the fields I want to extend belong to SalesQuotationDetailsTmp. Therefore, new data I bring in must be matched up with its specific Sales Quotation line (you can't just stuff all the new fields into a tmp table, the relationship to the specific individual Sales Quotation lines must be maintained).
If i want to extend the ISV's SalesQuotationDetails extension table again, is this possible? Or would I extend the base SalesQuotationDetails table for my custom model/SSRS Report, and then copy all of the fields that are in the ISV table extension over to my new table extension? Or would neither of these approaches work, and I'm better off using a new table and then basically joining the tables together in the SSRS Report?
