Order totals by state...

[Madapple]

First off, I used to use FM all the time - years ago - and could usually do whatever I needed... seems I have lost my FMskills though.

 

Here is what I have:

3 tables

 

table 1:  all orders placed: order number, order date, customer name, oder total

table 2:  is all customers: customer name, shipping address, billing address, total number of orders for that customer

table 3: list of people catalog was sent to

 

 

I need to create a report that will show me total sales from each state, total sales from each catalog recipient from each state

I think once I can figure out this report I can duplicate the thought process for all other reports I need to generate.

 

Currently I have relationships set between all 3 tables based on customer name. Problem with that - some customers share names so I want to verify an order to "Joe Smith in California" does not get assigned to "Joe Smith in New York" - though again I think once I figure out the state by state catalog sales I will be able to figure out the rest.

 

I HAVE searched for this - just so rusty I am having trouble wording the search to find what I need.

 

Any thoughts?

 

 

[Matthew F]

My suggestion is to give customer ID numbers, and have this be the primary match field, not their name.  An auto-enter serial number is probably the way to go, unless you have some other well defined customer IDs.  If you need to select customers IDs in a popup then you can define a value list to key off of customer IDs but  "also display values from second field" to display names.