If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Normalization
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 |
Thread Tools | |
Display Modes | |
|
|