I am not very strong in databases, so you must forgive any obvious
stupidity.
After having a good look at our Sales Managemend database, we decided
there is something basially wrong.
Our Agents sell financials to only a few customers. The database was
set up as...
Table Table (Join)
Table
Agent (AgentID ) (AgentID)( >Customer(CustomerID)
But we have Agents who have not sold yet and will always have that
scenario.
So we are creating
Table Table (Join)
Table Table
Agent (AgentID ) (AgentID)(CustomerID) >Customer(CustomerID)>Product
Type)(UnitsSold)(CustomerID)
I am trying to figure out my joins as to make sure we have our form
queries correct.
If I run a Make Table query with the old relationships, I can get the
(AgentID)(CustomerID)
Table.
What I will be missing is 400+ records. The Agents who have no sales
or orphan Austomers who have no agents.
Am I going about this the right way?
Sure would like a little guidance