John W. Vinson wrote:
Well i fix it by the way ... tell me one thing is it possible that i have a
combo box i will put assume a customer ID in it and this will fetch product
[quoted text clipped - 46 lines]
Commission amount in no
Commission amount in words

Ok. So you completely ignored or dismissed the earlier advice about how to
normalize your table? That's why you're having trouble!

A customer *does not have a chassis number*.

A customer *does not have a commission amount*.

Or do you want to limit your database so that each customer can own one and
only one vehicle, and have one and only one insurance policy?

based on the above mentioned fields my contract is generating. Now i have
another table Named as discrepancy the reason for that table is if there is
[quoted text clipped - 13 lines]
& similarly what will be the control for the rest of the fields. and which
property do i need to set

It sounds like you want to COPY the customer name, product, and so on from the
(non-normalized) Customer table into the Discrepancy table.

Don't.

That's not how relational databases work! You should store customer specific
information - *once and once only* - in the Customer table, and noplace else.
The discrepancy table will have a CustomerNo to LINK it to the Customer table,
but it will not contain any other fields from that table.

You can enter data into the table by using a Form based on the Customer table,
with a Subform based on the Discrepancy table, using Customer No as the
master/child link field. On the subform you will have fields such as the date
of discrepancy, reason, resolution etc.


So you want me to break the customer info, like Customer no, Name & Passport
number, and what about the vehicle information then ???? 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.. 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 ...

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
is purely replying on the above non normalized data ... or either i will make
a query which will take info from 2 - 3 tables and will create a table and
basis on that table i will generate the contract .. in addition to this a
user who is going to put information for the contract i will have to make a
sub form ???? means i dun want to make it complicated .. and I asked for the
wayout for searching like user put customer no in suppose combo box and the
information from other table will fetch in text box.

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

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