N
Norm
I have the responsibility of building my bank's Sales Tracking program
through Access 2003. I have to keep track of various areas: employee's,
location, new customer, why they opened their account, what product they
opened, how many, how much did they open for, & where the money is coming
from. My big issue is that customer's can open more than 1 product at a time
and use multiple checks to open their products. I can not figure out how to
link the different products and multiple checks. I have built only 1 table
for our products & 1 table for possible funds sources. Do I need to build
multiple tables for products & funds sources or I am just over thinking the
entire process? Please let me know.
through Access 2003. I have to keep track of various areas: employee's,
location, new customer, why they opened their account, what product they
opened, how many, how much did they open for, & where the money is coming
from. My big issue is that customer's can open more than 1 product at a time
and use multiple checks to open their products. I can not figure out how to
link the different products and multiple checks. I have built only 1 table
for our products & 1 table for possible funds sources. Do I need to build
multiple tables for products & funds sources or I am just over thinking the
entire process? Please let me know.