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?

 

Thanks.

Outcomes