Majid

These newsgroups offer FREE assistance and are (usually) "staffed" by
volunteers. The Code of Conduct for these newsgroups prohibits soliciting
paid work.

Before you do business with someone who solicits paid work here, ask
yourself if you are comfortable working with someone who knowingly violates
the rules here.

To make best use of the free assistance here, describe what you have and
what you have already done in more detail.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"sys_analyst47 via AccessMonster.com" u58607@uwe wrote in message
news:a4e335f442705@uwe...
Hi,
I am developing a inter dept application which will help us out to track
the
auto loan application receiving, status of application, daily activity of
staff & few more things beside that. The problem which i am facing to
design
tables is this I have a contract which needs to be issue to customer if
the
loan has approved which is based on 36 fields which are as under just
suggest
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??

Customer identification
Customer name Branch
Sales officer
Local purchase order date
Vendor
Vendor address
Brand
Model
Year of Make
Color
Chassis no
Engine no
Original cost
Insurance cost
Total cost Down payment
Total deferred payment
1st installment date
Last installment date
1st installment amount
Last installment amount
Place of registration
Vehicle owner name
Passport no
Debt account
Commission amount in no
Commission amount in words

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???

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

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/201003/1