Hello Majid,

I provide help with Access, Excel and Word applications for a small fee. If
you need help with your database, contact me.

Steve



"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