How to pull data for a field from another table?

[scottdev]

I want to have data for a particular field in one table (Table A) pulled from a field in another Access table (Table B) - which I was able to do using the lookup feature. But when I update the data in (Table B), the data in (Table A)does not update.

Is there something more involved I need to do to have the data automatically update in (Table A)?

 

[KenReay]

Hi

Is theer a comon column to relate the two tables together?, if yes, make a query, base for form on the query ratehr than table A, the you have all of the columns in both tables available in the form

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK