Table Help and Fill

[netking]

Hi I am new to Access.....coming from Paradox. In Paradox there is a feture ...table help and fill..The way it works is I identify a lookup table (lets say Customer.db) While working in (lets say orders.db). I lookup a value from the customer db and it automatically populates data from the customer db into the orders.db.

So if I enter a customer number in the order table information like the customers name and terms automatically appear in the order form..

How to I do this in Access. I am using Access 2000. I am stuck Ive looked everywhere!

Thanks!!

 

[petersdaniel]

If you are trying to do this at the Table level with out creating an Access form, you can acheive it as follows.

Lets assume that in your Orders table, you need to populate the a field called CustomerID. Your Customer Table contains the fields CutomerID, CustomerName, etc.

In the design mode of the Access ORDERS table, set your cursor on the CustomerID field (we'll assume that CustomerID from Customers is a LongInteger datatype and the CustomerID in Orders is also).

In the lower half of the screen you see two tabs General and Lookup. Click on the Lookup tab and you will see A dropdown box that lets you select Text, List or Combo. Set this to List. The screen will then change to show you places to enter a table or query source. Place your cursor on this and click the build button to create a query that pulls in CustomerID and Customer Name from Customer Table (CustomerID field should be in the first column in the query). make sure you set your column count to 2 on the lookup controls if you want to see both the ID and the Name

Save the table layout and when you put the table into data entry mode, you will be given a drop down list to populate the CustomerID field that shows the ID and name.

Hope this helps... petersdaniel@hotmail.com
"If A equals success, then the formula is: A=X+Y+Z. X is work. Y is play. Z is keep your mouth shut." --Albert Einstein