Start a new topic

SQL Table Relationships?

Hello - 


Has anyone come across any documentation that lists the table relationships for the database and how some of the main tables can be joined?


We are looking to do some internal reporting, but want to make sure we are properly joining tables.


Thanks

Amy



1 Comment

I'm not aware of any formal documentation but most of the table structures are pretty straightforward... DocumentItems.DocID >> DocumentHeaders.ID, DocumentItems.ManufacturerPartNumber >> Products.ManufacturerPartNumber , etc.


If there's a relationship that you are not sure about or if there's some particular BI report you want to get out of QuoteWerks, then please post details and I'll try to advise. 


Login or Signup to post a comment