John W. Vinson wrote:
Hi,
I am developing a inter dept application which will help us out to track the
[quoted text clipped - 4 lines]
me is there any way to split this ?? if i will split this in different tables
I have to setup a mail merge with Word So will i be able to do that??

A mailmerge can easily be based on a Query. You certainly do not need to have
it all in one table!

Customer identification
Customer name Branch
[quoted text clipped - 22 lines]
Commission amount in no
Commission amount in words

Each type or "Entity" - real-life person, thing, or event - should have its
own table. A Customer is an entity; an automobile is a different kind of
entity; a payment is yet a third type of entity. I'd suggest at LEAST tables
such as:

Customers
CustomerID autonumber primary key
LastName
FirstName
PassportNo you might be able to make this the primary key if every customer
will have one, but I doubt that is the case

SalesOfficers
OfficerID your company's employee number or an autonumber
LastName
firstName
other biographical or contact data

Vehicles
VehicleID I think the VIN is pretty standard
Make
Model
ModelYear
Color
other vehicle specific fields

Loan
LoanNo primary key, your unique loan number
LoanDate
PrincipalAmount
other loan terms

Fields which can be derived from other fields should not exist in your table,
period - they should instead be calculated on the fly. Amount in words is one
example. If the monthly payment can be calculated from the loan amount,
interest rate and term, then it should be calculated, not stored.

this is my customer table from where i generate contract.
The idea a customer record is entered there should be no redundancy. Please
don't forger that I have to issue contracts by mail merge. Or is there any
way to design report for contracts. it contains 12 pages for one customer.
can we design such a report???

Sure.


Thanks for your quick revert, well may i send you a copy of my database. if i
will keep separate vehicle table, sales table, customer table & Loan amount
table. How a user in one go will input the information .... can you please
suggest me on that. Please provide me your email so that i will send you a
copy of my database have a look into this and suggest me. I would really
appreciate your help

--
Thanks & Regards
Majid Pervaiz
Operations Analyst
Al Hilal Bank, Abu Dhabi, UAE

Message posted via http://www.accessmonster.com