John W. Vinson wrote:
So you want me to break the customer info, like Customer no, Name & Passport
number, and what about the vehicle information then ????

In a Vehicle table.

If i split it like
this how i will generate my contract which is based on mail merge & in mail
merge i think we can only take one table at one time..

You are mistaken.

You CAN base a mailmerge on a query.

As David Fenton pointed out in another thread, the query may not work if it
contains Access or VBA functions... but a simple join query *DOES INDEED* work
as the source of a mailmerge.

Even if it doesn't (for performance, or because you do need such a function),
you can maintain your data better if the tables are normalized. You can use a
(non-normalized) table as the source for the merge; empty it with a Delete
query and populate it with multitable data from your normalized queries with
an Append query.

Please suggest me if i
will generate a query based on the suppose non normalized customer table &
just fetch customer no,name, date based on that i make a table & then a form
for discrepancy and here i will just add one field for discrepancy. I know
its just a way out ...

I do not understand your question.

And if i split the customer info as mentioned above and vehicle info separate
?? the problem which i am looking is that how I will generate contract which
[quoted text clipped - 5 lines]
wayout for searching like user put customer no in suppose combo box and the
information from other table will fetch in text box.

Don't confuse DATA STORAGE - in tables, normalized - with DATA DISPLAY - a
Report, a printed contract, which can be an Access Report, a MailMerge from a
query, perhaps a MailMerge from a temporary table, perhaps even generated
using VBA and Word automation. Unless your contracts are one-time-only
printouts and you never need to deal with repeat customers or other repeating
data, your maintenance will be much easier with normalized tables.


Well i normalized the data & here are the details
customer:
customer number
cm name
installment amount
installment date

Vehicle:
customer number
Purchase order date
brand
model
year of make
color
chassis no
Insurance amount
total cost
profit amt
selling price
downpayment
deferred selling price
registration

and after that i create a subform. Correct me if i am wrong i will create a
query which will generate a table on basis of that i will prepare my contract.
Please tell me how can i make my contract by report because for one customer
there are 12 pages of contract how can i design 12 continuous pages in access
? is it possible

And just tell me one simple thing .. for amount i kept data type number & in
general i mentioned decimal with 2 digit after point but again in form when i
put a value it's getting round off ?? how can i set this

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