Complete fields in a form automatically?

Hello all,
Please could someone help me with my puzzle?
I am very new to Access and perhaps a little bit "tick"!

I am trying to design a Data Base for customer service.
One of my many problems is as follows.
I have a table for my customers with all customer details ie.
Customer name, type, account number, monthly rental/contract etc.

Then I have another table with job details, customer A/C number, name, type, monthly rental/contract (from customer table.

What I would like to do in the job table/form is simply enter the customers A/C number and have access fill in the customer name, type and monthly rental/contract.

Please could one of you experts out there help me?
I would be oh so grateful.
Brian.
Zimbabwe.

For starters If you are storing the customer A/C number, name, type, monthly rental/contract in the customer table, you should NOT be storing them the in the job detail too. All you would store in the job detail table is the field that identifies the customer (and based on what you have said it would be the customer A/C number). The you would like these tables together to display the customer information with the job when print the job detail.

Now if you would like to know how to bring that additional information over based on selecting an item from a combo box and by typing in a value into a text box. Look at the following thread and download a sampel DB I have there. The form of interest is frmCustomer and you will want to look at the after update event code in cmboCustNumber and the txtCustNumber.

http://forums.aspfree.com/showthrea...=52690#poststop

Now if you have any question about how to do this please ask and I will help you.


S-

Thanks for your assistance.
Sorry I have not replied sooner as connectivity from zimbabwe is rather poor.
Thank you and I will be asking LOTS more questions.