DLookUp

[Guest]

I consider myself an expert Excel user and an above average Access user. I
am having considerable trouble understanding the syntax and parts of the
dlookup function. Also would like some info on the appropriate use of the
quotes, brackets, etc. I know that if I can get some help with one dlookup
that relates to my database that I can figure it out.

I have 2 tables:

Table A name: customers
Table A fields: customer_id
customer
address
city
state
zip

Table B name: roll_data
Table B fields: job_number
project_number
customer_id
customer

I have a form based on Table B. I want to have the customer field in
table b to be poplulated with the appropriate customer field from Table A
based on the customer_id that is entered on Table/Form B.

Any help is greatly appreciated.

 

[Douglas J. Steele]

It would be a mistake to put customer as a field in the roll_data table. You
can get customer from the customers table any time you need it.

The same piece of data should never be stored in multiple places.

 

[Guest]

Table A should contain constant info for the most part. Table B contains
transactions or orders of a sort. I am trying to populate the customer
fields in Table B with the custoemr info from Table A as it was when the
order/transaction was entered. In other words, once the order/transaction is
entered and customer info captured, the customer fields do not need to update
later if the data changes in table A. For example; if a customer changes
address or name, the info in the old order will remain as it was when it was
entered.

I hope this helps explain what I am looking to do and thanks for such a
quick response.