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
sold from another table ...if so please let me know exactly how to do tht

Yes it is possible. However you will need to help me: I do not know the
structure of your tables, and I do not know where the product sold is to be
found.

Please post a description of your tables in the form

Customers
CustomerID
LastName
FirstName
...

OtherTable
Thisfield
Thatfield
...

and indicate how the tables are related.


Customer identification - Unique no assigned to every customer
Customer name Branch
Sales officer
Product
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

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
any error in customer finance application form i will have to return that
particular application. Fields of discrepancy are as under:

Customer No (FK)
Customer Name
Product
Branch
date of discrepancy - Will be same as Local purchase order date
Discrepancy reason

Now, if i will put the Customer Number i will get the customer name, product,
branch, date of local purchase order.
Tell me what will be the control for Customer number (Combo box or text box)
& similarly what will be the control for the rest of the fields. and which
property do i need to set

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