AnsweredAssumed Answered

Which table to place a count calculation

Question asked by sccardais on Jul 11, 2018
Latest reply on Jul 11, 2018 by philmodjunk

I have the table structure shown below. The purpose is to assign "standard" sources submitted on a form that are imported into the ORG table. The ORG::source_non_std is unstructured text. Examples might be: Web site, Google, Internet, web search. All of these are assigned a "standard" source name contained in the GLOSSARY table connected via the join.


This works but I also want to know how many from each source also Ordered the product as indicated by ORG::c_flag_ordered.


So, for each std_source in the GLOSSARY, I want a count of the ORGs that actually placed an order.


Which table should the calculation go into and is another relationship required?